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
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
