Question
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
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
ADD_MINUTES(ADD_HOURS("TABLE"."DATECOLUMN", 5),30)
Or, if you calcualate everything in minutes which will lead to
ADD_MINUTES("TABLE"."DATECOLUMN", 330)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.