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)