Hi, I have a file to import to postgresql that have an unusual date format. For example, Jan 20 2007 is 20022007, in DDMMYYYY format, without any separator. I know that a 20072002 (YYYYMMDD) is ok, but I don't know how to handle the DDMMYYYY dates. I tried and tried but I can't import those dates to postgresql. Any hint, other than editing file ? Regards, Diego. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq