Re: Timestamps in Views

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