Chapter 6 – Date Functions
"An inch of time cannot be bought with an inch of gold."
- Chinese Proverb
Getting the System Date
The example above shows you how to get the system date. You must get them from sysibm.sysdummy1.
Extracting From a Timestamp
Above are the keywords you can utilize to extract the day, month and year from the sysibm.sysdummy1 table.
The EXTRACT Command
This is the Extract command. It returns a date part, such as a day, month ...