GetDate()获得的日期由两部分组成,是今天的日期和当时的时间:
Select
GetDate
()
用DateName()就可以获得到相应的年、月、日,再把它们连接起来就好了:
Select
Datename
(
year
,
GetDate
())
+
'
-
'
+
Datename
(
month
,
GetDate
())
+
'
-
'
+
Datename
(
day
,
GetDate
())
另外,DateName()还可以获得到小时、时间、秒、星期几、第几周,分别如下:
Select
Datename
(hour,
GetDate
())
Select Datename (minute, GetDate ())
Select Datename (second, GetDate ())
Select Datename (weekDay, GetDate ())
Select Datename (week, GetDate ())
Select Datename (minute, GetDate ())
Select Datename (second, GetDate ())
Select Datename (weekDay, GetDate ())
Select Datename (week, GetDate ())