Skip to main content

I want to insert date-time data from one table to another but I am getting Execution error: ERROR: Column "event_time" is of type timestamp but expression is of type varchar error

Hi Abhishek,

 

Could you post your code. You may be missing a column in your column insert order or may have the ordering of the columns in the statement incorrect.

 

 


Hi

 

I have the similar problem.

Error message: "Execution error: ERROR: Column "EVENTTIME" is of type timestamp but expression is of type int"

 

Details:

  • I did the csv import of the salesorderheaders successfully (for PoC resons)
  • Created and inserted data into the
    • master activities table successfully
    • create sales order table successfully
    • sales order item delivered successfully
  • I got the error message when I came to the FixedDueDate. I did the insert in the master acitivities table with the "OrderCreateDate" and the "ConfirmedReceiptDate" but the FixedDueDate does not work although it comes from the same csv import and is also defined as datetime datatype.

 

Please let me know if you need more details.

 

Thanks for your help

Dieter


Reply