i have a column that contains date and time , i want to increase the time by 5 hours 30 minutes for each cell what would be the syntax for that . thankyou | Community

i have a column that contains date and time , i want to increase the time by 5 hours 30 minutes for each cell what would be the syntax for that . thankyou

Page 1 / 1

ADD_MINUTES(ADD_HOURS("TABLE"."DATECOLUMN", 5),30)

ADD_MINUTES(ADD_HOURS("TABLE"."DATECOLUMN", 5),30)

Or, if you calcualate everything in minutes which will lead to

ADD_MINUTES("TABLE"."DATECOLUMN", 330)

Reply