1f8a 无忧博客
1 页,共 1 标签:date-functions,共计 1 篇文章

DB2关于时间的一些函数

得到当前时间的年份、月份、天、小时等等: YEAR (current timestamp) MONTH (current timestamp) DAY (current timestamp) HOUR (current timestamp) MINUTE (current timestamp) SECOND (current timestamp) MICROSECOND (current timestamp) 分别得到当时的日期和时间 DATE (current timestamp) TIME (current timestamp) 关于时间的一些计算: current date + 1 YEAR cur… (阅读全文)

DB2关于时间的一些函数

得到当前时间的年份、月份、天、小时等等: YEAR (current timestamp) MONTH (current timestamp) DAY (current timestamp) HOUR (current timestamp) MINUTE (current timestamp) SECOND (current timestamp) MICROSECOND (current timestamp) 分别得到当时的日期和时间 DATE (current timestamp) TIME (current timestamp) 关于时间的一些计算: current date + 1 YEAR cur… (阅读全文)

0