Re: [GENERAL] datetime datatype question

Kevin Heflin wrote:
>
>
> If from the psql command line I use select current_timestamp it shows like
> this:
>
> 1999-10-01 14:30:53-05
>
> However if I insert into a datetime field, when I do a select it formats
> it like so:
>
> Sun Oct 03 10:00:00 1999 CDT
>
> Is there a way I can retrieve the information from a datetime field, and
> format it like the first example ?

rfb=> \h set
Command: set
Description: set run-time environment
Syntax:
SET DATESTYLE TO 'ISO'|'SQL'|'Postgres'|'European'|'US'|'NonEuropean'

it looks like

set datestyle to 'ISO'

to me..

Cheers,

Patrick

PS you could also set the environment variable PGDATESTYLE to ISO...