Thread: dates and encoding

dates and encoding

From
tony
Date:
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

NOTICE:  Current client encoding is 'UNICODE'
NOTICE:  Current server encoding is 'LATIN1'

Why is the client encoding different from the server encoding? They were
both the same in 7.1.x weren't they?

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


Re: dates and encoding

From
tony
Date:
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