| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Alex <alex(at)meerkatsoft(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Timestamps in Views |
| Date: | 2003-10-24 08:44:24 |
| Message-ID: | 200310240944.24740.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Friday 24 October 2003 02:13, Alex wrote:
> Richard,
> have a look I also don't quite understand why it is happening.
> The dates returned are actually not the creation date of the view but just
> a different date. Thanks
> # SELECT log_id AS lid,job_id AS jid, job_type AS jtype,
> to_char(job_start, 'YYYY-MM-DD HH:MM:SS') AS job_start,to_char(job_end,
> job_start | 2003-10-07 10:10:28
Ah! got it - you're using MM for month and minute. It'll be "m" or "i" or
something.
I've done the same, and looked at the code 100 times without noticing it.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2003-10-24 08:51:29 | Re: SCSI vs. IDE performance test |
| Previous Message | Peter Childs | 2003-10-24 08:30:57 | Re: Trigger |