Skip to Content
-3

SAP HANA SQL FUNCTION LOCALTOUTC - Day light savings

Hello, Please let me know how HANASQL function LOCALTOUTC handles day light saving..

As shown below , using LOCALTOUTC, +8 is added for PST to UTC time conversion.

But during daylight it should be +7

Aslo the FM IB_CONVERT_INTO_TIMESTAMP returns +7

capture.png (6.1 kB)
capture.png (9.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • This is apparently not an ABAP question.

  • you closed the question with the comment "The question is answered, right answer was accepted", but I do not see that you accepted the answer. You can still do it. If the only answer was not the right one then please share the solution you found yourself. A community lives from exchanging knowledge.

  • Get RSS Feed

1 Answer

  • Mar 28, 2017 at 09:01 PM

    I'm not a HANA expert but in the HANA example you are converting the date in January, which is not during daylight savings time. In the FM example you're converting the date in March 2017.

    Daylight savings time starts around March and runs till around November in the US. You can find more precise information on start/end dates in Google.

    Add comment
    10|10000 characters needed characters exceeded