skip to main
|
skip to sidebar
SQL Server Discussion
Wednesday, December 29, 2010
Retrieve Current Time in SQL
A line is compose for retreieving current time only from date in sql
(SELECT RTRIM(LTRIM(SUBSTRING(CAST(GETDATE() as varchar),12,len(CAST(GETDATE() as varchar))))))
Thanks,
Newer Posts
Older Posts
Home
Subscribe to:
Comments (Atom)
Followers
Blog Archive
►
2011
(1)
►
December
(1)
▼
2010
(6)
▼
December
(1)
Retrieve Current Time in SQL
►
November
(1)
►
June
(2)
►
May
(1)
►
April
(1)
About Me
Ayaz Zaidi
View my complete profile