I 'm struggling with an SQL query to convert a
timestamp to a
bigint, as this is how the table field that stores the date is defined. I have tried a number of things, but I always get errors with different error codes/states.
INSERT INTO "PUBLIC"."OFMESSAGEARCHIVE" ("CONVERSATIONID", "SENTDATE") VALUES (1, CONVERT (to_timestamp ('22/11/2008 20:30:40', 'DD/MM/YYYY HH:MI:SS' ), 'SQL_BIGINT') );
I tried with
CAST etc.but no luck. Any hints?