Dave
AFAIK MSSQL doesn't have a literal 'date' format, I always use the ansi
'2006-08-04' string which converts ok
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
--
Neven MacEwan (B.E. E&E)
Ph. 09 620 1356 Mob. 027 4749 062
New Address Details
===================
MWK Computer Systems
1 Taumata Rd
Sandringham
Auckland
Ph 620 1356
Fx 620 1336
begin:vcard
fn:Neven MacEwan
n:MacEwan;Neven
email;internet:[EMAIL PROTECTED]
tel;work:649 620 1356
tel;fax:649 620 1336
tel;cell:0274 749 062
version:2.1
end:vcard
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
