Re: [GENERAL] Default date format to ISO + 1 bug

On Thu, Jan 13, 2000 at 10:09:35AM -0500, Web Manager wrote:
> since I am a simple Postgres user, I don't understand the instruction to
> change the postgresql default date format from 01-13-2000 to 2000-01-13
>
> The timestamp format is OK with : 2000-01-13 09:11:24-05 but
> Date gives : month-day-year
>
> For Postgres v6.5 (and earlier) the default date/time style is
> "non-European traditional Postgres" (I guess that means that timestamp
> does not follow this default format). How do I change this?

you can use the set command to change the datestyle:
SET DATESTYLE TO 'ISO'|'SQL'|'Postgres'|'European'|'US'|'NonEuropean'

i set mine to 'ISO' which is 'yyyy-mm-dd hh:mm:ss-tz'

to make it permanent, you can set the environment variable PGDATESTYLE
in your startup script.

--
[ Jim Mercer jim(at)reptiles(dot)org +1 416 506-0654 ]
[ Reptilian Research -- Longer Life through Colder Blood ]
[ Don't be fooled by cheap Finnish imitations; BSD is the One True Code. ]