Postgres Pro
Downloads
Home   >   mailing lists

AM/PM times? Am I going crazy? - Mailing list pgsql-general

From Philip Hallstrom
Subject AM/PM times? Am I going crazy?
Date
Msg-id Pine.BSF.4.21.0008081124070.70120-100000@illiad.adhesivemedia.com
Whole thread Raw
Responses Re: AM/PM times? Am I going crazy?  (Karel Zak <zakkr@zf.jcu.cz>)
How to create an index using a function???  (Philip Hallstrom <philip@adhesivemedia.com>)
List pgsql-general
Tree view 
Hi -
    It appears that postgres considers 1pm to really be 1am???  The
following is occuring on 7.0.2.  Am I missing something obvious?


devloki=>  select CURRENT_TIMESTAMP;
       timestamp
------------------------
 2000-08-08 11:23:29-07
(1 row)

devloki=> select TO_CHAR(timestamp '2000-08-08 13:00:00-07', 'am');
 to_char
---------
 am
(1 row)

devloki=> select TO_CHAR(timestamp '2000-08-08 14:00:00-07', 'am');
 to_char
---------
 pm
(1 row)

pgsql-general by date:

Previous
From: Craig Anderson
Date:
Subject: Postgres Authentication Problems
Next
From: Karel Zak
Date:
Subject: Re: AM/PM times? Am I going crazy?