Announcement

Collapse
No announcement yet.

Conversion failed when converting datetime

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Conversion failed when converting datetime

    FAILURE: Error writing to database:
    SQLException
    Conversion failed when converting datetime from character string. Query: INSERT IGNORE INTO sma values (?, ?,0 ,0,0,0,0,0,0,0,0,0,0) Parameters: [0995819, 200808260357]


    I am getting this error? How to fix it?

  • #2
    Re:Conversion failed when converting datetime

    Can you post your channel please?

    If you are dealing with any datetime fields from a message make sure they are formatted so that your database can understand them.

    Post edited by: jbartels, at: 08/28/2008 05:39
    Jon Bartels

    Zen is hiring!!!!
    http://consultzen.com/careers/
    Talented healthcare IT professionals wanted. Engineers to sales to management.
    Good benefits, great working environment, genuinely interesting work.

    Comment


    • #3
      Conversion failed when converting date and/or time from character string.

      How do I address this issue?

      insert into table_name
      (first_name,last_name,creation_dt)
      values(${firstname},${Lastname},cast(${SYSTIME} as DATETIME)).

      I have tried to use cast and convert but still unable to insert data into the table. We are using SQL db and the column is datetime type.

      Can you please suggest a way to address this?

      Comment


      • #4
        Valuable information. Thank you for sharing.
        Clinical Research

        Comment

        Working...
        X