Received: from blount.mail.mindspring.net (blount.mail.mindspring.net [207.69.200.226]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f15GDdx24204 for ; Mon, 5 Feb 2001 11:13:39 -0500 (EST) (envelope-from bcdoyle@mindspring.com) Received: from hbg-ntd-467b.mindspring.com (fw-5-e3.atl2.mindspring.net [207.69.162.92]) by blount.mail.mindspring.net (8.9.3/8.8.5) with ESMTP id LAA10842; Mon, 5 Feb 2001 11:13:23 -0500 (EST) Message-Id: <5.0.2.1.2.20010205111017.02a06980@pop.internal.mindspring.com> X-Sender: bcdoyle@pop.internal.mindspring.com X-Mailer: QUALCOMM Windows Eudora Version 5.0.2 Date: Mon, 05 Feb 2001 11:13:14 -0500 To: Keith Perry , pgsql-sql@postgresql.org From: "Brian C. Doyle" Subject: Re: Problem with Day of Week In-Reply-To: <3A75AE8C.3E6D7F53@vcsn.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200102/50 X-Sequence-Number: 1220 Keith, Try: select to_char('now'::timestamp,'Dy'); to_char --------- Mon (1 row) ---------------------------------------------------------- DAY = full upper case day name (9 chars) Day = full mixed case day name (9 chars) day = full lower case day name (9 chars) DY = abbreviated upper case day name (3 chars) Dy = abbreviated mixed case day name (3 chars) dy = abbreviated lower case day name (3 chars) DDD = day of year (001-366) DD = day of month (01-31) D = day of week (1-7; SUN=1) ------------------------------------------------------------- Taken from http://www.postgresql.org/users-lounge/docs/7.0/user/functions2972.htm At 12:55 PM 1/29/01 -0500, Keith Perry wrote: >Greetings, > >I notice some talk about date problems and interestingly enough planning >out an application in which I will need to be able to manipulate dates. >I notice however that there seems to be a discrepancy with the day or >week in 7.0.3 > >--- > >pmhcc=# select date_part('dow','now'::timestamp); > date_part >----------- > 1 >(1 row) > >pmhcc=# select to_char('now'::timestamp,'D'); > to_char >--------- > 2 >(1 row) > >pmhcc=# select version(); > version >--------------------------------------------------------------------- > PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66 >(1 row) > >pmhcc=# select now(); > now >------------------------ > 2001-01-29 12:57:46-05 >(1 row) > >--- > >Now as far as I know, Sunday is supposed to 1, so I would think that >date_part is doing something funky unless I am mis-understanding >something. I was hoping that someone might be able to shead some light >on this. Thanks. > >Keith C. Perry >VCSN, Inc. >http://vcsn.com