Update Column with Type datetime

[Thomas609]

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

[Dan Guzman]

I have tried various statements like this and i think, the problem is

the blank between date and time.

The interpretation of this date string depends on the DATEFORMAT setting. I
suggest you use either of these 2 formats to avoid ambiguity:

'2007-12-17T08:49:04.000'
'20071217T08:49:04.000'

What is the data type of 'columndate_Name'? If the data type is other than
datetime or smalldatetime, you may get an error if the column contains
invalid datetime data.

--
Hope this helps.

Dan Guzman
SQL Server MVP

<Th*******@gmail.comwrote in message
news:dd**********************************@w56g2000 hsf.googlegroups.com...

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

[Madhivanan]

On Dec 17, 1:52 pm, [e-mail] wrote:

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

You need to express date values in universal YYYYMMDD HH:MM:SS format