Trying to enter Null in DateTime column

[stacy47]

Using SQL 7. When I try to pass a null value to a stored procedure which adds a new record, the value inserted into a datetime field is Jan 01, 1900. Have tried almost every conditional programming to force the null value, but to no avail. Any suggestions would be greatly appreciated. Thank you.

 

[rac2]

The secret is, do not insert any value for the date column.

CREATE TABLE nullsOnly (
id CHAR(10),
birthday DATETIME
)

INSERT INTO nullsOnly (id)
   VALUES ('xxx')

SELECT * FROM nullsOnly

 

[balves]

If you pass only a time to a datetime field, then you get 1/1/1900 as the date.

It depends how the datetime field was defined in the table. If it was defined as allowing NULLs, then you don't have to pass anything to it.