From: | "Colin Price (EML)" <Colin(dot)Price(at)eml(dot)ericsson(dot)se> |
---|---|
To: | "'Albert Chen'" <chen6178(at)hotmail(dot)com> |
Cc: | "'pgsql-general(at)postgreSQL(dot)org'" <pgsql-general(at)postgreSQL(dot)org> |
Subject: | RE: [GENERAL] Date convertion problem. |
Date: | 1999-07-06 10:53:58 |
Message-ID: | 5F052F2A01FBD11184F00008C7A4A8000289A9CA@eukbant101.ericsson.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)hotmail(dot)com]
> Sent: Tuesday, July 06, 1999 3:40 AM
> To: pgsql-general(at)postgreSQL(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan davis | 1999-07-06 12:22:21 | Re: [GENERAL] one problem |
Previous Message | Jonathan davis | 1999-07-06 10:24:31 | one problem |