StatCounter

View My Stats

Tuesday, February 5, 2008

To get Current Time in SQL Server

The query as Follows:

select CONVERT(char(5), CURRENT_TIMESTAMP,8)

No comments: