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 - 2006-08-10 : 09:45:55
|
| kaps writes "i tried to store date in sqlserver using insert statement but it stored the date as 1/1/1900..help me to storw the date in the database using insert statement.." |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-08-10 : 10:14:39
|
Like this...Insert into SomeTable(DateCol)values('04/02/2006')Can u be little specific and tell us what is the exact problem?Sample data? query ? etc.Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-08-10 : 13:02:47
|
| Use DateTime datatype and when supplting values use universal format YYYYMMDDInsert into SomeTable(DateCol)values('20060204')or make use of stored procedure with DateTime parameterMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
how to store date