|
|
Posted by tlyczko on 10/09/50 11:58
David Portas wrote:
> A DATETIME column doesn't have any specific format. SQL Server cannot
> control the format of dates as displayed by your client application.
> For that you have to use the features of your client app or development
> environment.Typically these might be based on the regional format
> defined in Windows Control Panel.
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
I was looking at the table itself through SSMS 2005, I did specify
above which server I was working in, there were no error messages, it
was an import using the wizard, but I'll remember the create/insert
etc. items next time.
Thank you, Tom
Navigation:
[Reply to this message]
|