Get(CurrentTimestamp)

Get(CurrentTimestamp)

Category: Get

Syntax: Get ( CurrentTimestamp )

Parameters: none

Description: Returns the current date and time according to the local system clock, to the nearest second.

Examples:

 Get (CurrentTimeStamp) 

Might return 1/25/2004 8:28:05 PM .

 Truncate ( Get (CurrentTimeStamp)/ 86400 ; 0 ) + 1 

Extracts the date from a timestamp.

 Mod ( Get (CurrentTimeStam); 86400 ) 

Extracts the time from a timestamp.

Comments:

Note that a timestamp is stored internally as an integer that represents the number of seconds since 1/1/0001. Therefore, calculations that use seconds as the base unit can be performed on timestamp data types.

Get (CurrentTimeStamp) uses the date and time settings of the local machine (client) and may be less useful than Get (CurrentHostTimeStamp) in a database that is accessed by clients from different time zones.