SQL date shows as string not date

[Re-Invented]

Hi all,

We have just set up an sql data server that takes all the data off our live server(aix box) so reporting can be done without affecting the main server.

It drops the tables, re creates them and imports data via odbc which all works great.

The only problem is when you link to a table say in access or crystal reporter it shows a date column as a string yet its clearly defined as a date column on the sql server?? if i change this to datetime it shows as datetime.

If i link to live data it shows as date in crystal reports??

If anyone has any ideas, that would be great.

Thanks
Lee

[vti_786]

do you think it could be something to do with the date format, e.g. dd/mm/yyyy

[Re-Invented]

How would i define this in sql then ??

Thanks
Lee

[shaithis]

You cannot force SQL Server to save dates differently.....it's all about how they are read back out.

Therefore, if you need to force Access or Crystal to datetime for them to appear as datetime, then that is what you need to do.

The default datetime format is determined by the language setting on the login you are using to access SQL Server.

[vti_786]

http://www.sql-server-helper.com/tips/date-formats.aspx

check out what date format is supported with access or what ever you need it for and use the above method(s) accordingly

[Re-Invented]

Thanks guys will just stay how it is then.

Thanks
Lee