|
Use the following constant functions to obtain the literal values that each of them returns:
| CURRENT_DATE | Returns the current system date. |
| CURRENT_TIME | Returns the current system time. |
| CURRENT_TIMESTAMP | Returns the current system date and time. |
| CURRENT_GUID | Returns a unique 38-byte GUID value in string format. |
| CURRENT_USER | Returns the User ID that is being used by Alventis to access the Server that this query belongs to. This function is an Alventis extension and may not be supported by other systems. |
All of these functions take no parameters, so you do not need to write empty parenthesis after them, for example:
SELECT CURRENT_DATE AS TodaysDate, ID FROM TableName
The date/time functions will return the Server's date/time if executed by a Remote Server (i.e., when the query belongs to a Remote Database).
| 
