CREATE TABLE T( dt DATE, tm TIME(0)); INSERT INTO T VALUES (DATE '2009-05-28', TIME '14:53:45'); SELECT dt, tm, CAST( dt AS TIMESTAMP(0)) + (tm - TIME '00:00:00' HOUR TO SECOND) ts FROM T; |
dt tm ts ---------- -------- ------------------- 2009/05/28 14:53:45 2009-05-28 14:53:45
Tags: TeradataTip