DB2 time functions _ time addition and subtraction

Time addition and subtraction: Remember to keep up with the time types such as day and hour

Timestamp (timestamp (def_time) + 1 day) + 18 hour

 

DB2 time functions are one of our most common functions. The following describes some DB2 time functions for your reference. We hope you can learn more about DB2 time functions.

2. -- Get the current date:
4.  
6. Select current date from sysibm. sysdummy1;
8. Values current date;
10.  
12. -- Get the current date
14. Select current time from sysibm. sysdummy1;
16. Values current time;
18. -- Get the current Timestamp
20. Select current timestamp from sysibm. sysdummy1;
22. Values current timestamp;
24.  
26. -- 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:
28.  
30. Values current time-current timezone;
32. Values current timestamp-current timezone;
34.  
36. -- Get the current year
38.  
40. Values year (current timestamp );
42.  
44. -- Get the current month
46. Values month (current timestamp );
48.  
50. -- Get the current day
52. Values Day (current timestamp );
54.  
56. -- Get current time
58. Values hour (current timestamp );
60.  
62. -- Get minutes
64. Values minute (current timestamp );
66.  
68. -- Get seconds
70. Values second (current timestamp );
72.  
74. -- Get millisecond
76. Values microsecond (current timestamp );
78.  
80. -- Extract the date and time from the time stamp
82.  
84. Values date (current timestamp );
86. Values varchar_format (current timestamp, 'yyyy-mm-dd ');
88. Values char (current date );
90. Values time (current timestamp );
92.  
94. -- Calculate the execution date and time
96.  
98. Values current date + 1 year;
100. Values current date + 3 years + 2 months + 15 days;
102. Values current time + 5 hours-3 minutes + 10 seconds;
104.  
106. -- Calculate the number of days between two dates
108.  
110. Values days (current date)-days (date ('1970-02-20 '));
112.  
114. -- Replace time and date with a string
116.  
118. Values char (current date );
120. Values char (current time );
122.  
124. -- Converts a string to a date or time value.
126.  
128. Values timestamp ('2017-03-09-22.43.00.000000 ');
130. Values timestamp ('2017-03-09 22:44:36 ');
132. Values date ('2017-03-09 ');
134. Values date ('2014/1/123 ');
136. Values time ('22: 45: 27 ');
138. Values time ('22. 45.27 ');
140.  
142. -- Calculate the time difference between two timestamps:
144.  
146. -- The decimal part of the second is in unit
148. Values timestampdiff (1, char (current timestamp-timestamp ('2017-01-01-00.00.00 ')));
150. -- Seconds
152. Values timestampdiff (2, char (current timestamp-timestamp ('2017-01-01-00.00.00 ')));
154. -- Unit
156. Values timestampdiff (4, char (current timestamp-timestamp ('2017-01-01-00.00.00 ')));
158. -- Hours
160. Values timestampdiff (8, char (current timestamp-timestamp ('2017-01-01-00.00.00 ')));
162. -- Days
164. Values timestampdiff (16, char (current timestamp-timestamp ('2017-01-01-00.00.00 ')));
166. -- Weekly
168. Values timestampdiff (32, char (current timestamp-timestamp ('2017-01-01-00.00.00 ')));
170. -- Month
172. Values timestampdiff (64, char (current timestamp-timestamp ('2017-01-01-00.00.00 ')));
174. -- Quarterly
176. Values timestampdiff (128, char (current timestamp-timestamp ('2017-01-01-00.00.00 ')));
178. -- Year
180. Values timestampdiff (256, char (current timestamp-timestamp ('2017-01-01-00.00.00 ')));