The one tricky thing with the DateFormatter is that the source dates MUST be in a known format. The acceptable formats are mm/dd/yy, monthname dd, yy, dd monthname yy, day, dd monthname yy, CCyymmdd, CCyy-mm-dd, dd-monthname-CCyy.
Your YYYYMMDD might work, but more likely you'll need to change it to something like mm/dd/yy first - the SubstringExtractor and Concatenator would be the best way to do that. Of course if you did this then Oracle might recognize it better anyway. Mark Mark Ireland, Product Support Engineer Safe Software Inc. Surrey, BC, CANADA [EMAIL PROTECTED] http://www.safe.com Solutions for Spatial Data Translation, Distribution and Access --- In [email protected], "Rice, Bob" <[EMAIL PROTECTED]> wrote: > 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/
