Help in get Time

[Senthil S]

hi all, we know getdate() function returns current date. I want get the current time. Can any one help me... Thanks in Advance Senthil S

Senthil.S Software Engineer

[DerekFL]

SELECT RIGHT(CONVERT(varchar(23), GETDATE(), 8),11)

[Blue_Boy]

select convert(varchar(15),getdate(),108)

---

I Love T-SQL "Don't torture yourself,let the life to do it for you."