[DUG] MSDE Date Conversion

[Peter Ingham]

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
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
>