select
GETDATE() as '系统当前日期',
DateName(year,GetDate()) as '年',
DateName(month,GetDate()) as '月',
DateName(day,GetDate()) as '日',
DateName(hour,GetDate()) as '时',
DateName(minute,GetDate()) as '分',
DateName(second,GetDate()) as '秒',
DateName(dw,GetDate()) as '星期',
DateName(week,GetDate()) as '周数'
SQL SERVER 获取系统当前日期、年、月、日、时、分、秒、星期、周数
于 2023-06-29 18:21:36 首次发布