2. it
  3. SqlServer 时间格式化

SqlServer 时间格式化

mac2022-06-30  65

select GETDATE() as '当前日期',

DateName(year,GetDate()) as '年',DateName(month,GetDate()) as '月',DateName(day,GetDate()) as '日',DateName(dw,GetDate()) as '星期',DateName(week,GetDate()) as '周数',DateName(hour,GetDate()) as '时',DateName(minute,GetDate()) as '分',DateName(second,GetDate()) as '秒'

转载于:https://www.cnblogs.com/jimmyLei/p/10662235.html

相关资源：JAVA上百实例源码以及开源项目
最新回复(0)