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 - 2001-11-28 : 09:07:08
|
| falcon_ette writes "HiWhen I insert a date into the table of my sql server database it inserts the wrong date.I am running a session on my asp page and inserting that session into the database.When the session is eg.12/05/2001, it is of the format dd/mm/yyyy, it inserts a date of 05/12/2001. The problem is when I call up the value added into the table on another asp page I get the wrong date. Which is making the calculation of another value wrong on that page.Pleez help driving me insane.falcon_ette" |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2001-11-28 : 09:27:47
|
| If you want to make your life easier, always convert all dates you pass to the SQL Server into ISO format (yyyymmdd)... That way you are guaranteed that SQL Server will interpret the date correctly, regardless of your regional settings. |
 |
|
|
|
|
|
Inserting date problem