All Forums Database
dsreddy117 20 posts Joined 11/07
27 Dec 2007
subtracting from Timestamp column.

Hi, I am copying from one teradata table to another. Both the tables having timestamp(0) columns and the format is 'YYYY-MM-DDBHH:MI:SS'. While copying i need to perform table2 timestamp column = (table1 timestamp column - 6 hours). Thanks in advance

dsreddy117 20 posts Joined 11/07
27 Dec 2007

I tried with the below SQL, but it's not workingSel current_timestamp(0)- (time '06:00:00') hour to second(0)

Fred 1096 posts Joined 08/04
31 Dec 2007

Tryselect current_timestamp(0) - interval '6' hour;

dsreddy117 20 posts Joined 11/07
02 Jan 2008

Thanks Fred!

You must sign in to leave a comment.