Generally '1 Jan 2001 12:59:33pm' however this does not always work as some DB's do work differently with times.
But give it a go, Just remember to pass as a string -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Traci Sumpter Sent: Friday, 4 August 2006 1:32 p.m. To: 'NZ Borland Developers Group - Delphi List' Subject: RE: [DUG] MSDE Date Conversion 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
