Getting the actual date and time values
In the previous sections, we dealt with the date and time value composition from the character string format, providing examples of mappings to ensure the reliability and correctness of the processing. There are, however, two functions for each data type (DATE and TIMESTAMP) producing the actual date and time values.
We will intentionally not use the keyword current in this section, as current is a function name used in database processing. It reflects the client site by emphasizing region and time zone processing. The term actual is not used as a keyword by the client or server site and represents states or date and time values that are in effect at this moment.
The sysdate and current_date functions can be used when dealing with the DATE data type. sysdate is a SQL function that gets the actual date and time elements referencing the operating system of the database server. Thus particular values are normalized based on the server parameters...
