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@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
