Asp.Net,C#,Sql Server 2005
Monday, May 14, 2012
Retrieve only Time in sql
Hello to all Now i will tell you that how to fetch only time from GetDate() function
SELECT LTRIM(RIGHT(CONVERT(VARCHAR(20), GetDate() , 100), 7))
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment