Skip to main content
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

  • April 7, 2022
  • 2 replies
  • 33 views
.
Level 4
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

    2 replies

    G
    Level 12

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

    florian.mrkvi
    Level 7
    Forum|alt.badge.img+3

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

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

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

    Community Code of ConductAccessibility statement