Forgot your password?
Document Actions
How to use date functions on DB2
dayname, dayofwwek, month, monthname
How to calculate the date difference with days as result:
db2 "SELECT days(current date) - days(date(2008-08-05)) FROM sysibm.sysdummy1"
How to calculate the date difference with date as result:
db2 "SELECT (current date) - date(2008-08-05) FROM sysibm.sysdummy1"
| SQL Date and Time Functions | ||
| DAYNAME | Returns a mixed case character string containing the name of the day (e.g., Friday) for the day portion of the argument. | |
| DAYOFWEEK | Returns the day of the week in the argument as an integer value in the range 1-7, where 1 represents Sunday. | |
| DAYOFWEEK_ISO | Returns the day of the week in the argument as an integer value in the range 1-7, where 1 represents Monday. | |
| DAYOFYEAR | Returns the day of the year in the argument as an integer value in the range 1-366. | |
| DAYS | Returns an integer representation of a date. | |
| JULIAN_DAY | Returns an integer value representing the number of days from January 1, 4712 B.C. (the start of Julian date calendar) to the date value specified in the argument. | |
| MIDNIGHT_SECONDS | Returns an integer value in the range 0 to 86 400 representing the number of seconds between midnight and the time value specified in the argument. | |
| MONTHNAME | Returns a mixed case character string containing the name of month (e.g., January) for the month portion of the argument. | |
| TIMESTAMP_ISO | Returns a timestamp value based on date, time or timestamp argument. | |
| TIMESTAMP_FORMAT | Returns a timestamp from a character string that has been interpreted using a character template. | |
| TIMESTAMPDIFF | Returns an estimated number of intervals of the type defined by the first argument, based on the difference between two timestamps. | |
| TO_CHAR | Returns a character representation of a timestamp that has been formatted using a character template. TO_CHAR is a synonym for VARCHAR_FORMAT. | |
| TO_DATE | Returns a timestamp from a character string that has been inter-preted using a character template. TO_DATE is a synonym for TIMESTAMP_FORMAT. | |
| WEEK | Returns the week of the year of the argument as an integer value in range 1-54. The week starts with Sunday. | |
| WEEK_ISO | Returns the week of the year of the argument as an integer value in the range 1-53. | |
Hacker Rangers - Gamification for CyberSecurity