Will leap second impact ASE?

[Former Member]

A leap second will be inserted at the end of June.

(used NTP to sync the time)

Any SAP notes talk about this?

Will leap second impact ASE?

Is the following ASE message relay?

Warning: The internal timer is not progressing. If this messages is generated multiple times, report to Sybase Technical Support and restart the server(alarminterval=-577028)

[Former Member · Accepted solution]

Not really.

If the system clock jumps forwards, the ASE internal clock will jump ahead eventually.

If the system clock jumps backwards, the ASE internal clock slows down for the system clock to catch up. 

Personally, I never understood why servers are using any other time than UTC.  Let the client applications deal with local time.

jason

[former_member188958 · Accepted solution]

One way that the leap second does affect ASE is in datediff() calculations - the results of calculations over a range that include the leap second will now be off by a second because the calculations don't know about the leap second.

-bret

[c_baker · Accepted solution]

SAP KBA 2053685 discusses this:

https://service.sap.com/sap/support/notes/2053685

Chris