How do I get only the time out of getdate()?

You will need to extract it to a character attribute


so this will give you time as HH:MM:SS

select convert(char(8), getdate(),108)





--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]