This article introduces you to the date and time functions in DB2 and some instructions for your reference.
DAYNAME returns a string of both upper and lower cases. For the day part of the parameter, the name of the day is represented by week, for example, Friday ).
DAYOFWEEK returns the day of the week in the parameter, expressed by an integer ranging from 1 to 7, where 1 represents Sunday.
DAYOFWEEK_ISO returns the day of the week in the parameter, expressed by an integer ranging from 1 to 7, where 1 represents Monday.
DAYOFYEAR returns the day of the year in the parameter, expressed by an integer ranging from 1 to 366.
DAYS returns an integer of the date.
JULIAN_DAY returns the number of days from the start date of the rulecalendar on January 1, January 1, 4712 BC to the specified date value in the parameter, expressed in an integer.
MIDNIGHT_SECONDS returns the number of seconds between midnight and the specified time value in the parameter, which is expressed by an integer ranging from 0 to 86400.
MONTHNAME returns a string, such as January, in combination with upper and lower cases, for the month of the parameter month ).
TIMESTAMP_ISO returns a time stamp Value Based on the date, time, or time stamp parameter.
TIMESTAMP_FORMAT returns a timestamp from a string interpreted using a character template.
TIMESTAMPDIFF returns the estimated time difference expressed by the type defined by the first parameter based on the time difference between the two timestamps.
TO_CHAR returns the time stamp character representation formatted using the character template. TO_CHAR is a synonym for VARCHAR_FORMAT.
TO_DATE returns a timestamp from a string that has been interpreted using a character template. TO_DATE is a synonym for TIMESTAMP_FORMAT.
WEEK returns the WEEK number of the year in the parameter, expressed by an integer ranging from 1 to 54. Start from Sunday.
WEEK_ISO returns the week of the year in the parameter, which is expressed by an integer ranging from 1 to 53.
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:
Current time-current timezone
Current timestamp-current timezone
Given a date, time, or time stamp, you can use an appropriate function to extract the year, month, day, hour, minute, second, And microsecond parts if applicable:
YEAR (current timestamp)
MONTH (current timestamp)
DAY (current timestamp)
HOUR (current timestamp)
MINUTE (current timestamp)
SECOND (current timestamp)
MICROSECOND (current timestamp)