Re: Postgre 7.3.x Bug with datetime formatting.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Safwan Hak" <safwan_hak(at)sympatico(dot)ca>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Postgre 7.3.x Bug with datetime formatting.
Date: 2004-05-07 01:17:21
Message-ID: 26880.1083892641@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Safwan Hak" <safwan_hak(at)sympatico(dot)ca> writes:
> select current_timestamp, to_char(current_timestamp, 'YYYY-MM-DD
> HH:MM:SS:US')

> 2004-05-05 13:25:12.332313 2004-05-05 12:05:12:332313

Looks fine to me. I suspect what you are wanting is HH24:MI:SS, not
HH:MM:SS.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2004-05-07 01:33:19 Re: [BUGS] BUG #1148: server restarts depending on stats options
Previous Message Bruce Momjian 2004-05-06 22:10:21 Re: BUG #1148: server restarts depending on stats options