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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-05-25 : 08:41:08
|
| JJ writes "I have transaction software utilizing SQL Server 2000 Standard SP3 on a Windows NT 4.0. The database is used to store transaction dates in addition to other info. The software runs perfectly on other clients machines, yet the machines in my office have problems selecting a saving the date. I am unable to select today's date and when saving any date, the year is changed to 1899. Updates/reinstalls of the software does not fix the problem. Other clients using the same software and database version do not have the problem. The only thing I have not done is a reinstall of SQL Server. The software is built using VB 6. Is SQL Server behind this problem?Thanks." |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-05-25 : 09:49:54
|
| If you do a select getdate() what does it return?? |
 |
|
|
|
|
|
Saving Dates in SQL Server