2053685 - How do leap seconds affect the SAP ASE, SAP SQL Anywhere, SAP Repserver and SAP IQ databases -SAP ASE

A leap second is a second that is added or removed to a specific time on June 30 or December 31, in order to coordinate the difference between Universal Time (UT1) and Coordinated Universal Time (UTC).

The operating system will automatically adjust the system time for the leap second.

Announced leap seconds to date (as of 1 Jan 2021)

Year	Jun 30	Dec 31
2016		+1
2015	+1	0
2012	+1	0
2008	0	+1
2005	0	+1
1998	0	+1
1997	+1	0
1995	0	+1

How do leap seconds affect SAP Adaptive Server Enterprise (ASE), SAP SQL Anywhere, SAP RepServer and SAP IQ?

Read more...

• SAP Adaptive Server Enterprise (ASE), all versions
• SAP IQ, all versions
• SAP SQL Anywhere, all versions
• SAP Replication Server (REP server), all versions

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.1 ; SAP IQ 16.0 ; SAP IQ 16.1 ; SAP SQL Anywhere 16.0 ; SAP SQL Anywhere 17.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4 ; SAP Sybase SQL Anywhere 12.0 ; SQL Anywhere 9.0 ; Sybase Adaptive Server Enterprise 12.5 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5 ; Sybase SQL Anywhere 10.0 ; Sybase SQL Anywhere 11.0

UTC, mean solar time, sybase, IQ, ASE, SQLAnywhere, database , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-IQ , Sybase IQ , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , How To