Re: Date Anomaly??

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Good <tomg(at)sqlclinic(dot)net>
Cc: Ian Barwick <barwick(at)gmx(dot)net>, Postgres SQL List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Date Anomaly??
Date: 2003-05-07 16:13:05
Message-ID: 27677.1052323985@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Thomas Good <tomg(at)sqlclinic(dot)net> writes:
> Bottom line: there is no way to return a MM-DD-YYYY value?

Certainly:

regression=# set DateStyle TO postgresql,us;
SET
regression=# select 'today'::date;
date
------------
05-07-2003
(1 row)

Perhaps you are confused by the difference between timestamp and date?

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Achilleus Mantzios 2003-05-07 16:33:24 An unresolved performance problem.
Previous Message Thomas Good 2003-05-07 16:02:16 Re: Date Anomaly??