extract(c1 from d1)
【功能】:日期/时间d1中,参数(c1)的值
【参数】:d1日期型(date)/日期时间型(timestamp),c1为字符型(参数)
【参数表】:c1对应的参数表详见示例
【返回】:字符
【示例1】
select extract(hour from timestamp '2001-2-16 2:38:40 ') 小时,
extract(minute from timestamp '2001-2-16 2:38:40 ') 分钟,
extract(second from timestamp '2001-2-16 2:38:40 ') 秒,
extract(DAY from timestamp '2001-2-16 2:38:40 ') 日,
extract(MONTH from timestamp '2001-2-16 2:38:40 ') 月,
extract(YEAR from timestamp '2001-2-16 2:38:40 ') 年
from dual;
【示例2】
select extract(YEAR from date '2001-2-16') from dual;
【示例3】
select sysdate 当前日期,
extract(hour from systimestamp) 小时,
extract(DAY from sysdate) 日,
extract(MONTH from sysdate) 月,
extract(YEAR from sysdate) 年
from dual;
extract(c1 from d1)
最新推荐文章于 2024-02-06 18:28:22 发布