Thomas Good <tomg@sqlclinic.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