Update Column with Type datetime

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Thomas609@gmail.com
    #1

    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_Nam e' = convert(datetim e,
    '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
    Tags: None
    • Dan Guzman
      #2
      Re: Update Column with Type datetime

      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_Nam e'? 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

      <Thomas609@gmai l.comwrote in message
      news:dd9db43c-9580-4fc4-b396-f87fa2b2a7dd@w5 6g2000hsf.googl egroups.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_Nam e' = convert(datetim e,
      '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

        Comment

        • Madhivanan
          #3
          Re: Update Column with Type datetime

          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_Nam e' = convert(datetim e,
          '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

            Comment

            Previous template Next
            Working...