is it possible to explicity insert values in timestamp column of DB2

Question

Hi, is it possible to explicity insert values in timestamp column of DB2? For example i have a date time value '2\11\2005 4:59:36 PM'. How to convert it to timestamp value in DB2?

Thanks in advance

Answer 1

INSERT INTO TimeStampTable(TIMESTAMPFIELD, ...) VALUES ((TIMESTAMP(CAST('04.02.2005' AS VARCHAR(10)),'13:14:53')),...)