Re: dates and encoding

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