try 'Insert into Table (aDate) values (''#'+FormatDateTime('yyyy-mm-dd
hh::nn::ss', Now)+'#'')' ;
Using a single : in the time gets misinterpreted as being a parameter in
some cases.
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
