>SQL Server treats NULL Date as 01/01/1900. It's a default behaviour.
>
>Bye
>Jayesh
>
>>When I have a view which reads a date field with no value in it, the view uses a default date with 1899 or something like that. Is this considered standard behaviour? Is there an easy way to sidestep this?
>>
>>Thanks,
>>
>>Peter
Thanks to all of you! Problem solved!
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only