sql获取时间

BEGIN --时间获取

–获取当前时间(如：yyyymmdd hh:MM:ss)
SELECT GETDATE()
–获取当前时间(如：yyyymmdd)
SELECT CONVERT (nvarchar(12),GETDATE(),112)
–获取当前日期(如：yyyy-mm-dd)
SELECT Datename(year,GetDate())+’-’+Datename(month,GetDate())+’-’+Datename(day,GetDate())
SELECT convert(char(10),getdate(),120)
–获取当前日期(如：yyyy/mm/dd)
SELECT DATENAME(YEAR,GETDATE())+’/’+DATENAME(MONTH,GETDATE())+’/’+DATENAME(DAY,GETDATE())–获取当前日期(如：yyyy/mm/dd)
–获取当前年份(YYYY)
SELECT DATENAME(YY,GETDATE())
SELECT left(convert(char(10),getdate(),120),4)
–获取当前月份(MM)
SELECT DATENAME(MM,GETDATE())
–获取当前日期(DD)
SELECT DATENAME(DD,GETDATE())
–获取当前小时(hh)
SELECT dateName(hh,getdate())
–获取当前分钟(DD)
SELECT DATENAME(MI,GETDATE())
–获取当前秒(如：25)
SELECT DATENAME(SECOND,GETDATE())
–获取当前周(如：20第二十周)
SELECT DATENAME(WEEK,GETDATE())
–获取当前星期(如：星期五)
SELECT DATENAME(WEEKDAY,GETDATE())
–获取当前时间(如：09:56:15)
SELECT convert(char(8),getdate(),108)

select TO_CHAR(TO_DATE(b.data_dt,‘YYYY/MM/DD’), ‘IYYYIW’) as week from dual

select * from fy_SpecialBusinessUnit order by createdtime desc
END