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,