I get timestamps in the following formats:



20050120232143015Z or 20050203171600Z-0400



I want to store these in Oracle as a Timestamp (or Date). I don't want to
truncate any of the information, I need it all. How do I get both of these
into my table as column data?





Anthony Smith
Programmer Analyst
International Technologies
901-263-8953



"Having education and talent doesn't make you better than the world... it
makes you responsible for it!"




Oracle LazyDBA home page