Tony Caduto <tony_caduto@xxxxxxxxxxxxxxxxxxxx> writes: > I have a user who is getting this error on a 8.1.3 server when importing > some data from a dbf file: > ERROR: date/time field value out of range: "08-01-2006" He needs to set DateStyle to match the expected field order. regression=# show datestyle; DateStyle ----------- ISO, MDY (1 row) regression=# select '08-01-2006'::date; date ------------ 2006-08-01 (1 row) regression=# set datestyle TO ymd; SET regression=# select '08-01-2006'::date; ERROR: date/time field value out of range: "08-01-2006" HINT: Perhaps you need a different "datestyle" setting. regression=# He might also want to use tools that don't suppress the HINT part of an error message ... regards, tom lane