On 29/12/2014 17:25, Suresh Raja wrote:
> clock_timestamp() gives more than I need. i just need time, - no date,
> or msec or timezone. How can i get to print the current time alone.
>
Please don't top-post; the convention on this list is to bottom-post, as
it makes discussions easier to follow.
Depending on your needs, you could use to_char() to format the value of
clock_timestamp() as you wish. This outputs a string rather than a time
value, but would be fine for logging, say.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie