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 |
|
glkrr
Starting Member
2 Posts |
 Posted - 2002-05-16 : 04:19:40
|
| Hi everybodyI have small doubt query on Sql ServerI wrote like this query in Query analyser.I created one table named dd"create table dd(dt date/time);After that when i insert this query"insert into dd values('')"Then i get the result date "1900-01-01 00:00:00.000".So what is the reason this date will come ..Edit by Merkin : Putting it in the right forumEdited by - merkin on 05/16/2002 08:48:03 |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-05-16 : 11:40:01
|
| I think we've had this on the forum a couple days ago. date time fields cannot contain blanks. either a null or a date... inserting a blank inserts 1900-01-01 00:00:00.000ways to get around this... instead of inserting a blank, insert a null.Put a trigger on the table that formats the date inserted to something other then blankthird, don't insert a blank into it ;) |
 |
|
|
|
|
|
Insering pbm