[DUG] MSDE Date Conversion

[Traci Sumpter]

As a rule I ALWAYS use '1 Jan 2004' for dates because it works or is
understood by all the database I have dealt with (and that's a few)

 

-----Original Message-----
From: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz] On
Behalf Of Dave O'Brien
Sent: Friday, 4 August 2006 1:06 p.m.
To: NZ Borland Developers Group - Delphi List
Subject: [DUG] MSDE Date Conversion

I am using MSDE for the first time and am having problems with dates. I have
had this problem with dates on all the DB's I have used. I can just never
work out the format...

'Insert into Table (aDate) values (''#'+FormatDateTime('yyyy-mm-dd
hh:nn:ss', Now)+'#'')' ;

What format string should I use for this to work?
Using DBGo TADOQuery...

Cheers,
David O'Brien.


_______________________________________________
Delphi mailing list
Delphi at ns3.123.co.nz
http://ns3.123.co.nz/mailman/listinfo/delphi