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