get_internal_date

Returns the current date and time from the internal clock maintained by the SAP ASE server.

Syntax

get_internal_date

Examples

Usage

get_internal_date may return a different value than getdate. getdate returns the system clock value, while get_internal_date returns the value of the server’s internal clock.

At startup, the SAP ASE server initializes its internal clock with the current value of the operating system clock, and increments it based on regular updates from the operating system.

The SAP ASE server periodically synchronizes the internal clock with the operating system clock. The two typically differ by a maximum of one minute.

The SAP ASE server uses the internal clock value to maintain the date of object creation, timestamps for transaction log records, and so on. To retrieve such values, use get_internal_date rather than getdate.

Permissions

Any user can execute get_internal_date

Related reference
getdate