oracle 取周

最新推荐文章于 2024-10-05 19:58:52 发布

deche3275

最新推荐文章于 2024-10-05 19:58:52 发布

阅读量68

点赞数

文章标签：数据库 php

原文链接：http://www.cnblogs.com/pan11jing/archive/2009/09/21/1570726.html

版权

select to_char(to_date('20090108','YYMMDD'),'IW') from dual ;
select to_char(to_date('20090108','YYMMDD'),'WW') from dual ;

select to_char(to_date('20090107','YYMMDD'),'IW') from dual ;
select to_char(to_date('20090107','YYMMDD'),'WW') from dual ;

IW：Week of year (1-52 or 1-53) based on the ISO standard.
WW：Week of year (1-53) where week 1 starts on the first day of the year and continues to the seventh day of the year.
参考资料 http://www.techonthenet.com/oracle/functions/to_date.php

转载于:https://www.cnblogs.com/pan11jing/archive/2009/09/21/1570726.html