Null Datetime field contains 1-Jan-1900

[Patrick Baird]

I have defined fields in a table as datetime fields and allow nulls. SQL 6.5 is placing 1-Jan-1900 in all of these fields causing me to have to filter out these dates when retrieving a recordset.
How do I get rid of this?


thanks!

[John Thorpe]

SQL Server does not store a date if NULL is sent to it, however if the value 0 (zero) is sent to the date field it will display as 1-Jan-1900, so look at how you populate this field.

On 2/10/99 10:14:02 PM, Patrick Baird wrote:
> I have defined fields in a table as datetime fields and allow nulls. SQL
> 6.5 is placing 1-Jan-1900 in all of these fields causing me to have to
> filter out these dates when retrieving a recordset.
How do I get rid of
> this?


thanks!