Date problems
Cho Yan Wong <pwong@pobox.leidenuniv.nl>
From: Cho Yan Wong <pwong@pobox.leidenuniv.nl>
To: pgsql-general@postgresql.org
Date: 1998-06-11T12:28:12Z
Lists: pgsql-general
Hello, I have some problems entering date fields. Wether I do: copy Photographer from 'mydir/db.txt' using delimiters ';'; or insert into Photographer values (1,2,'12-07-1974'); All dates are messed up. The month and day fields are ok, but the year value changes to something weird like 32768, 26673 or similarly large numbers. Everything else seems to be fine. Any ideas? How do I manipulate date fields. I;ve tried: select extract(Year from Birth) from Photographer; but that doesn't seem to work. I'm using PSQL 6.0 on IRIX6. Any help is appreciated. Tempest