AM/PM times? Am I going crazy?

From: Philip Hallstrom <philip(at)adhesivemedia(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: AM/PM times? Am I going crazy?
Date: 2000-08-08 18:27:44
Message-ID: Pine.BSF.4.21.0008081124070.70120-100000@illiad.adhesivemedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karel Zak 2000-08-08 18:35:29 Re: AM/PM times? Am I going crazy?
Previous Message Don Baccus 2000-08-08 17:27:53 Re: Re: [GENERAL] Trouble with float4 afterupgrading from 6.5.3 to 7.0.2