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 - 2000-10-24 : 16:52:39
|
Paul writes "My ASP pages used to pull up times, and they would show up '01/01/1900 05:25' now they show up '1/1/1900 5:25'
the problem is that the guy who originally wrote the pages used mid(tempTime, 9, 5) to get the times, and the places are now all off. unless i want to do wholesale changes to the pages, i need to get the pages to report dates with the 0's again.
i checked the servers control panel, and the settings are still mm/dd/yyyy.
paul13" |
|
|
|
|
|
smalldatetime '1/1/1900' instead of '01/01/1900'