-
null datetime field
Hi, I am trying to load data into a smalldatetime field from a flatfile. The data that looks like this '20001201' I have no problem converting to a smalldatetime field. However, sometimes there is no date, the date looks like this '00000000'. When I try and convert this to a smalldatetime field I get an out of range error message. Is there any way to have a date field that looks like this 0000-00-00?
-
null datetime field (reply)
select CONVERT(varchar(10), GETDATE(), 120)
------------
Care at 3/5/01 9:55:04 AM
Hi, I am trying to load data into a smalldatetime field from a flatfile. The data that looks like this '20001201' I have no problem converting to a smalldatetime field. However, sometimes there is no date, the date looks like this '00000000'. When I try and convert this to a smalldatetime field I get an out of range error message. Is there any way to have a date field that looks like this 0000-00-00?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|