《2014--DB2日期SQL语句查询大全》由会员分享,可在线阅读,更多相关《2014--DB2日期SQL语句查询大全(3页珍藏版)》请在金锄头文库上搜索。
1、- 日 期:2014-04-07 - 整理人:太阳- 格 式:yyyymmdd,yyyy-mm-dd,yyyy/mm/dd- 1 获取当前年份- varchar_format(year(CURRENT date )- 2 获取当前月份- varchar_format(month(CURRENT date )- 3 获取当前日- varchar_format(day(CURRENT date )- 4 获取当前日期- varchar_format(CURRENT date ,yyyy-mm-dd)- 5 获取昨天日期- varchar_format(CURRENT date -1 day,yyy
2、y-mm-dd)- 6 获取本月的第一天- varchar_format(CURRENT date - day(current date) days + 1 days,yyyy-mm-dd)- 7 获取本月的最后一天- varchar_format(CURRENT date + 1 month - day(current date) days,yyyy-mm-dd)- 8 获取上月的第一天- varchar_format(CURRENT date - 1 month - day(current date) days + 1 days,yyyy-mm-dd)- 9 获取上月的最后一天- varc
3、har_format(CURRENT date - day(current date) days,yyyy-mm-dd)- 10 获取上年底的日期- varchar_format(CURRENT date - (month(current date)- 1 ) month - day(current date) days,yyyy-mm-dd)- 11 获取本年底的日期- varchar_format(year(CURRENT date)|-12|-31)- 12 获取本年几季度- varchar_format(quarter(CURRENT date)- 13 获取去年上月底- varcha
4、r_format(CURRENT date - 365 days - day(current date) days,yyyy-mm-dd)- 14 获取年初至现在多少天- varchar_format(DAYOFYEAR(CURRENT date) - 15 获取上年初第一天- varchar_format(CURRENT date - (month(current date) +11) month - (day(current date)-1) days,yyyy-mm-dd)- 16 获取本年初第一天- varchar_format(CURRENT date - (month(curren
5、t date) - 1) month - (day(current date)-1) days,yyyy-mm-dd)- 17 获取后年初第一天- varchar_format(CURRENT date - (month(current date) -13) month - (day(current date)-1) days,yyyy-mm-dd)- 1 获取当前年份select varchar_format(year(CURRENT date ) as yc from KJB_BLDKLSXH_T;- 2 获取当前月份select varchar_format(month(CURRENT
6、date ) as yc from KJB_BLDKLSXH_T;- 3 获取当前日select varchar_format(day(CURRENT date ) as yc from KJB_BLDKLSXH_T;- 4 获取当前日期select varchar_format(CURRENT date ,yyyy-mm-dd) as yc from KJB_BLDKLSXH_T;- 5 获取昨天日期select varchar_format(CURRENT date - 1 day,yyyy-mm-dd) as yc from KJB_BLDKLSXH_T;- 6 获取本月的第一天sele
7、ct varchar_format(CURRENT date -day(current date) days + 1 days,yyyy-mm-dd) yc from KJB_BLDKLSXH_T;- 7 获取本月的最后一天select varchar_format(CURRENT date + 1 month - day(current date) days,yyyy-mm-dd) as yc from KJB_BLDKLSXH_T;- 8 获取上月的第一天select varchar_format(CURRENT date - 1 month - day(current date) day
8、s + 1 days,yyyy-mm-dd) as yc from KJB_BLDKLSXH_T;- 9 获取上月的最后一天select varchar_format(CURRENT date -day(current date) days,yyyy-mm-dd) as yc from KJB_BLDKLSXH_T;- 10 获取上年底的日期select varchar_format(CURRENT date - (month(current date)- 1 ) month - day(current date) days,yyyy-mm-dd) as yc from KJB_BLDKLSX
9、H_T;- 11 获取本年底的日期select varchar_format(year(CURRENT date)|-12|-31) as yc from KJB_BLDKLSXH_T;- 12 获取本年几季度select varchar_format(quarter(CURRENT date) as yc from KJB_BLDKLSXH_T;- 13 获取去年上月底select varchar_format(CURRENT date - 365 days - day(current date) days,yyyy-mm-dd) as yc from KJB_BLDKLSXH_T;- 14
10、 获取年初至现在多少天select varchar_format( DAYOFYEAR(CURRENT date) as yc from KJB_BLDKLSXH_T;- 15 获取上年初第一天select varchar_format( CURRENT date - (month(current date) +11) month- (day(current date)-1) days,yyyy-mm-dd) as yc from KJB_BLDKLSXH_T;- 16 获取本年初第一天select varchar_format( CURRENT date - (month(current date) -1) month- (day(current date)-1) days,yyyy-mm-dd) as yc from KJB_BLDKLSXH_T;- 17 获取后年初第一天select varchar_format( CURRENT date - (month(current date) -13) month- (day(current date)-1) days,yyyy-mm-dd) as yc from KJB_BLDKLSXH_T;