db2中的日期和时间（Date and time in db2）.docVIP

db2中的日期和时间（Date and time in db2） 1 basic knowledge 2 date function 3 modify date format 4 customer date/time format Section 5 This article aims to let DB2 beginners understand DB2 the date and time of application, believe that most people used other databases will be surprised to find that in DB2 operation how easy it is to date and time. This article applies to IBM DB2 Universal Database for Linux, UNIX, and Windows. 1 basic knowledge To get the current date, time and timestamp with the SQL statement, you can use the corresponding DB2 register: SELECT current date FROM sysibm SELECT current time FROM sysibm.sysdummy1 SELECT current timestamp FROM sysibm The sysibm.sysdummy1 table is a special table in memory that you can use to get the value of the DB2 register. You can also use the keyword VALUES to get the value in the register. For example, in the DB2 command line processor, you can use the following SQL statement to get the same information: VALUES the current date VALUES the current time VALUES to current timestamp In the example below, I will only provide functions or expressions, instead of repeating SELECT... FROM sysibm.sysdummy1 or use the VALUES clause. To adjust the current time or current timestamp to Greenwich mean time (GMT/CUT), the current time or time stamp can be deducted from the current time zone register: Current time - current timezone Current timestamp - current timezone Given a date, time, or timestamp, use appropriate functions to extract (if applicable) years, months, days, hours, minutes, seconds, and microseconds: YEAR (current timestamp) The MONTH (current timestamp) DAY (current timestamp) HOUR (current timestamp) MINUTE (current timestamp) The SECOND (current timestamp) MICROSECOND (current timestamp) Extracting dates and time from timestamps is also very simple: The DATE (current timestamp) TIME (current timestamp) You can also use English (because there are no better terms) to perform date and time calculations: Current date + 1 YE