Time letter summary in DB2 database (1)

This article describes the classification of time functions in DB2 databases for your reference.

Summary of DB2 time functions:

Code
-- Get the current date:

Select current date from sysibm. sysdummy1;
Values current date;

-- Get the current date
Select current time from sysibm. sysdummy1;
Values current time;
-- Get the current Timestamp
Select current timestamp from sysibm. sysdummy1;
Values current timestamp;

-- To adjust the current time or current time stamp to GMT/CUT, subtract the current time or time stamp from the current time zone register:

Values current time-current timezone;
Values current timestamp-current timezone;

-- Get the current year

Values year (current timestamp );

-- Get the current month
Values month (current timestamp );