Board index » delphi » Dephi 2.01& SQL Serveur big Bug

Dephi 2.01& SQL Serveur big Bug

Hello,

I'm trying to use the datetime fields with Delphi and SQL Server.
SQL Server requires a date format as follows : 01/01/1901 00:00:000 and
Delphi trys to post following format : 01/Jan./1901 00:00:000.
As you can understand SQL Server puts me off.

Do you know, by any chance :
- if there is a way of changing date format for SQL Server
- if there is a way of changing Delphi date format

I've tried already all combinations in Delphis format file BDECFG32.EXE

If one of you has time to spare good luck

Thanks

Xavier

 

Re:Dephi 2.01& SQL Serveur big Bug


Hi, Xavier!

See the Delphi help on FormatDateTime() - this allows you
to change the way the date/time values are formatted.

HTH

Ken
--
kwh...@westelcom.com
qpwpla...@aol.com

Clipper Functions 3.0 for Delphi
http://members.aol.com/clipfunc

Quote
LEMAIRE Xavier wrote:

> Hello,

> I'm trying to use the datetime fields with Delphi and SQL Server.
> SQL Server requires a date format as follows : 01/01/1901 00:00:000 and
> Delphi trys to post following format : 01/Jan./1901 00:00:000.
> As you can understand SQL Server puts me off.
[SNIP]
> If one of you has time to spare good luck

> Thanks

> Xavier

Other Threads