Community Member Profile

Recent Blog Comments By Curious

• Careful When Trying To CAST DATETIME AS INT

  Posted on May 30, 2007 at 4:31 PM

  Sorry, I copy and past wrong text. here your go test the following lines and you will know the difference... select cast('11 Jan 2007 4:00am' as datetime), cast(cast('11 Jan 2007 4:00am' as datetime) as float), cast(cast('11 Jan 2007 4:00am' as datetime) as int), cast(cast(cast('11 Jan 2007... read more »

• Careful When Trying To CAST DATETIME AS INT

  Posted on May 30, 2007 at 4:27 PM

  Test this one and you will know! select cast('11 Jan 2007 11:00pm' as datetime), cast(cast('11 Jan 2007 11:00pm' as datetime) as float), cast(cast('11 Jan 2007 11:00pm' as datetime) as int)... read more »