RE: [GENERAL] Date convertion problem.

To set date styles for your dB (Look for the SET command
at the User guide documentation for a full explanation) :
    - At runtime level :
        test=> show DATESTYLE;
        test=> SET DATESTYLE TO 'ISO';
    - At boot up (/etc/rc.d/init.d/postgres) :
        Add :
             export PGDATESTYLE=ISO
        just before executing postmaster ....
    - At database level :
        $ postgres <options> <database>
            - option -e = European
        see $ man postgres
    - At user level :
        Add in to shell startup (Eg .bash_profile) :
            export PGDATESTYLE=ISO

    To see what format you're getting :
        SELECT datetime 'now';
        select date 'now';




> -----Original Message-----
> From: Albert Chen [mailto:chen6178@hotmail.com]
> Sent: Tuesday, July 06, 1999 3:40 AM
> To: pgsql-general@postgreSQL.org
> Subject: [GENERAL] Date convertion problem.
>
>
> Hi,
>
> I have a problem about date convertion.
> I insert a value which attribute is date, like this:
>
> insert into example values ('19 Mar 1999');
>
> How do I show the date become 1999/3/19?
>
> Thanks in advance,
> Albert.
>
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>