Re: localtime(0)

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@iol.ie