[DUG] MSDE Date Conversion

[Bevan Edwards]

Hi Dave,

For MSSQL and MSDE I always use the ODBC format of {d 'yyyy-mm-dd'}, {t 
'hh:nn:ss'} and {ts 'yyyy-mm-dd hh:nn:ss'}.

However, I think that 'yyyy-mm-dd' will work in almost all cases anyway.

Regards,

Bevan


Dave O'Brien wrote:
> 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
> 
>