| From: | tony <tony(at)animaproductions(dot)com> |
|---|---|
| To: | postgres list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: dates and encoding |
| Date: | 2002-02-28 12:00:49 |
| Message-ID: | 1014897649.1852.28.camel@vaio |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 2002-02-27 at 09:20, tony wrote:
> Been fooling around a bit with settings
>
> NOTICE: DateStyle is ISO with European conventions
>
> Great but how do I get set date2 = date 'date1' + interval '30 days' to
> work? it gives a "bad external date representation" error
On a follow up how do I get to_char(columnwithdate, 'DD-MM-YYYY')
to work on a SELECT of several date values?
Cheers
Tony Grant
--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | OtisUsenet | 2002-02-28 16:57:27 | Help with SET TRANSACTION in a function |
| Previous Message | Justin Clift | 2002-02-28 11:36:49 | [Fwd: RE: Advisory 012002: PHP remote vulnerabilities (fwd)] |