| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | rod(at)iol(dot)ie |
| Cc: | Suresh Raja <suresh(dot)rajaabc(at)gmail(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: localtime(0) |
| Date: | 2014-12-29 18:56:13 |
| Message-ID: | 17212.1419879373@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Raymond O'Donnell" <rod(at)iol(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Van Dyk | 2014-12-29 18:57:38 | 9.3.6 release? |
| Previous Message | Raymond O'Donnell | 2014-12-29 18:35:13 | Re: localtime(0) |