problem with date and to_char
От | postgresql |
---|---|
Тема | problem with date and to_char |
Дата | |
Msg-id | 200201091601.g09G1nB17973@postgresql.org обсуждение исходный текст |
Ответы |
Re: problem with date and to_char
|
Список | 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 по дате отправления: