begin dbms_output.put_line(TO_CHAR(TO_DATE('20031225', 'YYYYMMDD'))); end; prints out 25-Dec-2003 for me. So, TO_DATE('20031225', 'YYYYMMDD') should do the trick to throw that string into a date. -----Original Message----- From: Luther, Ron [mailto:ron.luther at hp.com] Sent: Tuesday, August 26, 2003 12:17 PM To: List (E-mail) Subject: [thelist] Oracle Date Swizzle? Hi Gang, I've got a *text* field in a database populated with values like '20031225' that I need to do a little date arithmetic on. I'm using an older version of Oracle. Any handy-dandy simple solutions? Thanks, RonL. [Currently eyeball deep in "TO_DATE(TO_CHAR(SUBSTR ( Open_Detail.Customer_Dt, 5, 2 )) || CHR(45) || TO_CHAR(SUBSTR ( Open_Detail.Customer_Dt, 7, 2 )) || CHR(45) || TO_CHAR(SUBSTR ( Open_Detail.Customer_Dt, 1, 4 )), 'MM-DD-YYYY')" nonsense that doesn't seem to be properly cutting the cheese. Grrr.] -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !