Add 10 minutes to timestamp

General
Enthusiast

Add 10 minutes to timestamp

I have a time column with the following format.

This column doenst have date,month and year

I want to add 10 minutes to this column .

Time (FORMAT '99:99:99', TITLE 'THETIME'),

 

I tried to use interval fucntion but it is not working

 time + interval '10' minute

2 REPLIES
Senior Apprentice

Re: Add 10 minutes to timestamp

You need to cast to string first and then to time:

Cast(Trim(theTime) AS TIME(0))+ INTERVAL '10' MINUTE
Tourist

Re: Add 10 minutes to timestamp

I have a time column with the following format.

 

19-04-1980 00:00:00:0000

ADD TO MINUTES TO TIMESTAMP

 

Capture.PNGCapture1.PNG