Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group