"Raymond O'Donnell" <rod@iol.ie> writes:
> 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.
EXTRACT() might help, too.
regards, tom lane