View Single Post

   
  #1 (permalink)  
Old 03-01-2008, 03:46 PM
Thomas609@gmail.com
 
Posts: n/a
Default Update Column with Type datetime

Hi,

I want to update a column typed datetime. My statement is:

update 'tablename' set Datum_Ende = '2007-12-17 08:49:04.000' where
'columnID_name' = 23250 and 'columndate_Name' = convert(datetime,
'17.12.2007 08:08:04')

This effects an error. The Server said, the dateTime value is out of
valid Domain.

I have tried various statements like this and i think, the problem is
the blank between date and time.

Can someone help me?

Thanks

Thomas
Reply With Quote