Re: localtime(0)

"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