problem with date and to_char - Mailing list pgsql-sql

From postgresql
Subject problem with date and to_char
Date
Msg-id 200201091601.g09G1nB17973@postgresql.org
Whole thread Raw
Responses Re: problem with date and to_char
List pgsql-sql
I am a little stumped.
postgresql 7.1.3
suse linux 7

I have a database with

CREATE TABLE "fc_communication" ("acode" character varying(12),"conversation" text,"contactdate" date

CREATE TABLE "comm_date" ("lastcontact" timestamp with time zone DEFAULT 'now' NOT NULL,Constraint "comm_date_pkey"
PrimaryKey ("lastcontact")
 

When I update fc_communication I also (without a trigger) update 
comm_date with a sep  

update comm_date set lastcontact = 'now';

it works beautifully if I do a psql
'select * from comm_date;'

2002-01-08 16:16:03

I always get the last moment that someone updated the communications file

however what I want to do is:
SELECT to_char(lastcontact, 'Month DD, YYYY   HH:MM') from comm_date;


January   08, 2002   04:01

why is this 04:01?

Every time I do this I get the very first date (that no longer exists). 
Why do I get different results. I expect 'select *' is the base and 
everything else is a varient.

Ted
tedpet@symcom.com




pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Nested loops and $13
Next
From: Torbjörn Andersson
Date:
Subject: Re: Nested loops and $13