sql中如何获取当前时间

sql 中如何获取当前时间

sql中日期类型datetime类型字段默认格式为yyyy-MM-dd hh:mm:ss: mmm

获取当前日期

获取当前时间：select getdate() //返回格式为默认格式
获取当前时间的年：select datename(year,getdate())
获取当前时间的月：select datename(month,getdate())
获取当前时间的日：select datename(day,getdate())
获取当前时间的小时：select datename(hour,getdate())
获取当前时间的分钟：select datename(minute,getdate())
获取当前时间的秒：select datename(second,getdate())
获取当前时间是本周第几天：select datename(weekDay,getdate())
获取当前时间是当年第几周：select datename(week,getdate())

获取格式化的日期

注：yy代表不带世纪位数，eq.22，yyyy代表带世纪位数 eq.2022,mmm代表毫秒数
select convert(varchar(100), getdate(), 0) MM(月份英语缩写) dd yyyy hh:mmAM/PM (eq. Jun 13 2022 10:41AM)
select convert(varchar(100), getdate(), 1) MM/dd/yy (eq. 06/13/22)
select convert(varchar(100), getdate(), 2) yy.MM.dd (eq. 22.06.13)
select convert(varchar(100), getdate(), 3) dd/MM/yy (eq. 13/06/22)
select convert(varchar(100), getdate(), 4) dd.MM.yy (eq. 13.06.22)
select convert(varchar(100), getdate(), 5) dd-MM-yy (eq. 13-06-22)
select convert(varchar(100), getdate(), 6) dd MM(月份英语缩写) yy (eq. 13 Jun 22)
select convert(varchar(100), getdate(), 7) MM(月份英语缩写) dd, yyyy (eq. Jun 13, 22)
select convert(varchar(100), getdate(), 8) hh:mm:ss (eq. 10:45:01)
select convert(varchar(100), getdate(), 9) MM(月份英语缩写) dd yyyy hh:mm:ss:mmmAM/PM (eq. Jun 13 2022 10:45:56:860AM)
select convert(varchar(100), getdate(), 10) MM-dd-yy (eq. 06-13-22)
select convert(varchar(100), getdate(), 11) yy/MM/dd (eq. 22/06/13)
select convert(varchar(100), getdate(), 12) yyMMdd (eq. 220613)
select convert(varchar(100), getdate(), 13) dd MM yyyy hh:mm:ss:mmm (eq. 13 Jun 2022 10:47:37:620)
select convert(varchar(100), getdate(), 14) hh:mm:ss:mmm (eq. 10:48:13:063)
select convert(varchar(100), getdate(), 20) yyyy-MM-dd hh:mm:ss (eq. 2022-06-13 10:48:33)
select convert(varchar(100), getdate(), 21) yyyy-MM-dd hh:mm:ss.mmm (eq. 2022-06-13 10:49:08.070)
select convert(varchar(100), getdate(), 22) MM/dd/yy hh:mm:ss AM/PM (eq. 06/13/22 10:49:31 AM)
select convert(varchar(100), getdate(), 23) yyyy-MM-dd (eq. 2022-06-13)
select convert(varchar(100), getdate(), 24) hh:mm:ss (eq. 10:50:20)
select convert(varchar(100), getdate(), 25) yyyy-MM-dd hh:mm:ss.mmm (eq. 2022-06-13 10:50:41.860)
select convert(varchar(100), getdate(), 100) MM(月份英语缩写) dd yyyy hh:mAM/PM (eq. Jun 13 2022 10:51AM)
select convert(varchar(100), getdate(), 101) MM/dd/yyyy (eq. 06/13/2022)
select convert(varchar(100), getdate(), 102) yyyy.MM.dd (eq. 2022.06.13)
select convert(varchar(100), getdate(), 103) dd/MM/yyyy (eq. 13/06/2022)
select convert(varchar(100), getdate(), 104) dd.MM.yyyy (eq. 13.06.2022)
select convert(varchar(100), getdate(), 105) dd-MM-yyyy (eq. 13-06-2022)
select convert(varchar(100), getdate(), 106) dd MM(月份英语缩写) yyyy (eq. 13 Jun 2022)
select convert(varchar(100), getdate(), 107) MM(月份英语缩写) dd, yyyy (eq. Jun 13, 2022)
select convert(varchar(100), getdate(), 108) hh:mm:ss (eq. 10:53:33)
select convert(varchar(100), getdate(), 109) MM(月份英语缩写) dd yyyy hh:mm:ss:mmmAM/PM (eq. Jun 13 2022 10:53:50:270AM)
select convert(varchar(100), getdate(), 110) MM-dd-yyyy (eq. 06-13-2022)
select convert(varchar(100), getdate(), 111) yyyy/MM/dd (eq. 2022/06/13)
select convert(varchar(100), getdate(), 112) yyyyMMdd (eq. 20220613)
select convert(varchar(100), getdate(), 113) dd MM(月份英语缩写) yyyy hh:mm:ss:mmm (eq. 13 Jun 2022 10:54:53:940)
select convert(varchar(100), getdate(), 114) hh:mm:ss:mmm (eq. 10:55:19:817)
select convert(varchar(100), getdate(), 120) yyyy-MM-dd hh:mm:ss (eq. 2022-06-13 10:55:39)
select convert(varchar(100), getdate(), 121) yyyy-MM-dd hh:mm:ss.mmm (eq. 2022-06-13 10:56:02.380)
select convert(varchar(100), getdate(), 126) yyyy-MM-ddthh:mm:ss.mmm (eq. 2022-06-13T10:56:24.320)
select convert(varchar(100), getdate(), 130) dd mon yyyy hh:mm:ss:mmmAM/PM (eq. 14 ?? ?????? 1443 11:05:18:710AM)
select convert(varchar(100), getdate(), 131) dd/mm/yy hh:mi:ss:mmmAM/PM (eq. 14/11/1443 11:06:33:303AM)