Bryan, If you are using workbench, then the DateFormatter will do the trick. One caution, if you have any dates that are either null or 0, the DateFormatter will output the current date.
Bob -------------------------------------- L. Robert Rice P2 Energy Solutions 1625 Broadway Suite 500 Denver Co 80202 Office: 720-493-6663 Fax: 720-493-6681 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of hallkbrdz Sent: Friday, September 02, 2005 12:34 PM To: [email protected] Subject: [fme] Converting YYYYMMDD date to Oracle Date What is the easiest way to convert an integer stored YYYYMMDD date (from shapefile or PGDB) into Oracle? The date tool doesn't understand this format. Thanks, Bryan - FME Newbie Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our Professional Services team. Visit www.safe.com/services for details. Yahoo! Groups Links Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our Professional Services team. Visit www.safe.com/services for details. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
