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