[DUG] MSDE Date Conversion

[Dave O'Brien]

How do you deal with time in that format?

-----Original Message-----
From: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz]
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: 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

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