DB2 date time datetime
year(current timestamp)month(current timestamp)
day(current timestamp)
hour(current timestamp)
minute(current timestamp)
second(current timestamp)
microsecond(current timestamp)
以上7个函数都返回integer类型。
可以使用在date，time，timestamp类型上，包括current timestamp，current date，current time
数据表DKF_CUSTOMER_BILL_CYCLE的bill_date为date类型
select * from DKF_CUSTOMER_BILL_CYCLE where BILL_DATE = '2011-5-21 00:08:01';
等价于（截取）
select * from DKF_CUSTOMER_BILL_CYCLE where BILL_DATE = '2011-5-21';
等价于
select * from DKF_CUSTOMER_BILL_CYCLE where BILL_DATE = date('2011-5-21 09:08:01');
--2010-8-12 0:00:00
SELECT current date FROM sysibm.sysdummy1;
--10:06:47
SELECT current time FROM sysibm.sysdummy1;
--2010-8-12 10:06:55
SELECT current timestamp FROM sysibm.sysdummy1;
--2010-8-12 0:00:00
SELECT date (CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;
--10:06:47
SELECT time (CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;
--2010
SELECT YEAR (CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;
--8
SELECT MONTH (CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;
--12
SELECT DAY (CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;
--10
SELECT HOUR (CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;
--35
SELECT MINUTE (CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;
--20
SELECT SECOND (CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;
--23153
SELECT MICROSECOND (CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;
SELECT CURRENT TIMESTAMP + 1 YEAR + 1 MONTH + 1 DAY + 1 HOUR + 1 MINUTE + 1 SECOND + 1 MICROSECOND FROM SYSIBM.SYSDUMMY1;
SELECT CURRENT TIMESTAMP + 2 YEARS + 2 MONTHS + 2 DAYS + 2 HOURS + 2 MINUTES + 2 SECONDS + 2 MICROSECONDS FROM SYSIBM.SYSDUMMY1;
页:
[1]