Thread: dates and encoding
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
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