SQL 数据库
数据库中查询时间精确到秒 方法是什么？
[解决办法]
1> select
2> DATEPART ( year , getdate() ) as year,
3> DATEPART ( month , getdate() ) as month,
4> DATEPART ( day , getdate() ) as day,
5> DATEPART ( hour , getdate() ) as hour,
6> DATEPART ( minute , getdate() ) as minute,
7> DATEPART ( second , getdate() ) as second,
8> DATEPART ( millisecond , getdate() ) as millisecond
9>
10> go
year
[解决办法]
month
[解决办法]
day
[解决办法]
hour
[解决办法]
minute
[解决办法]
second
[解决办法]
millisecond
-----------
[解决办法]
-----------
[解决办法]
-----------
[解决办法]
-----------
[解决办法]
-----------
[解决办法]
-----------
[解决办法]
-----------
2010
[解决办法]
9
[解决办法]
24
[解决办法]
17
[解决办法]
30
[解决办法]
56
[解决办法]
647
(1 rows affected)
1>
5> DATEPART ( hour , getdate() ) as hour,
6> DATEPART ( minute , getdate() ) as minute,
7> DATEPART ( second , getdate() ) as second,
8> DATEPART ( millisecond , getdate() ) as millisecond
