Datetime issue

[niall5098]

HI THERE,

I have an issue at the moment whereby a datetime column has data reading like:

2010-01-26 15:08:17.930

The server language setting is american english.

Apart from a convert sql statement to read data in a certain way, is there any way i can have the date entered in the format as dd-mm-yyyy.

The column gets it date from getdate() finction.

Thanks in advance.

 

[bborissov]

DateTime values are saved the same way NO MATTER what are your current setting.

HOW to represent data and entered it is your FrontEnd Job, not SQL Server one.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.