Question

SQL 语法请教 如何获取系统时间

SELECT GETDATE() 可以获取系统时间，但太精确了，只要得到天或小时，或分钟 怎么写呢 谢谢

Answer 1

SELECT
'当前时间'
AS
[精度],
GETDATE()
AS
[结果]
UNION
ALL
SELECT
'精确到天'
AS
[精度],
DATEADD(dd,
DATEDIFF(dd,
0,
GETDATE()),
0)
AS
[结果]
UNION
ALL
SELECT
'精确到小时'
AS
[精度],
DATEADD(hh,
DATEDIFF(hh,
0,
GETDATE()),
0)
AS
[结果]
UNION
ALL
SELECT
'精确到分'
AS
[精度],
DATEADD(mi,
DATEDIFF(mi,
0,
GETDATE()),
0)
AS
[结果]
精度
结果
----------
-----------------------
当前时间
2012-11-03
16:08:06.597
精确到天
2012-11-03
00:00:00.000
精确到小时
2012-11-03
16:00:00.000
精确到分
2012-11-03
16:08:00.000
(4
行受影响)