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 me?

Thanks

Thomas

> 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 s.

Dan Guzman
SQL Server MVP

<Thomas609@gmail.com> wrote in message
news:dd9db43c-9580-4fc4-b396-f87fa2b2a7dd@w56g2000hsf.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 me?
>
> Thanks
>
> Thomas

On Dec 17, 1:52 pm, Thomas...@gmail.com 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 me?
>
> Thanks
>
> Thomas


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