Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Default value 1/1/1900 I don't want 1
- Thread starter krizsy
- Start date
-
1
- #2
nigelrivett
IS-IT--Management
It's because you are putting 0 instead of null in the field.
A datetime is held as the number of days from 1 jan 1900 so 0 will give you that date.
======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
A datetime is held as the number of days from 1 jan 1900 so 0 will give you that date.
======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
- Thread starter
- #3
Why not? When you highlight the column in "Design Table" you can put a default value in the bottom table. Is it nullable?
INSERT myTable (field1, dateField) VALUES ('some text',null)
Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)
- Status
Similar threads
