Results 1 to 2 of 2

Thread: null datetime field

  1. 03-05-2001, 09:55 AM #1
    Care Guest

    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?
    Reply With Quote Reply With Quote
  2. 03-05-2001, 02:20 PM #2
    Chris Thibodeaux Guest

    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?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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