Re: dates and encoding - Mailing list pgsql-general

From tony
Subject Re: dates and encoding
Date
Msg-id 1014897649.1852.28.camel@vaio
Whole thread Raw
In response to dates and encoding  (tony <tony@animaproductions.com>)
List 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


pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: [Fwd: RE: Advisory 012002: PHP remote vulnerabilities (fwd)]
Next
From: Gavin Scott
Date:
Subject: Re: Defunct postmasters