Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Server date swapping

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-01-23 : 09:51:42
Chandni writes "This is a strange problem. We use the getDate function to display the date a content is added to the SQL database

This date is in the mm/dd/yy format. However, occassionaly this swaps to the dd/mm/yy format. Or, a data added on todays date (01/23/2001), the date displayed is 01/11/2002 !

Please help as to why this could be happening.

We use a SQL server7 and Windows NT"
   

- Advertisement -