Thanks Thomas for the reply, the below statement outputs the time in 24h, but I needed it to display in hh:mm:ss AM/PM format.

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

Select Convert(Varchar(8), GetDate(), 8)

[/quote]