I have a varchar(20) field in my database and we want the data to look like
this:


ODR_TM
------------
11350062
11350137
11350158
11350186
11350197
11350203
11350221
11350231
11350238
11350244
11350250

which is time in hours, minutes, seconds, and hundreds of seconds.

However, we are getting it from another source like this:


ODR_TM
--------------------
20020618124000000000
20020618124000000000
20020618124000000000
20020618124000000000
20020618124000000000
20020618124000000000
20020618124000000000
20020618124000000000

which is year, day, hour, minutes.

How do we convert the data coming in to what we want in the database? Also,
how do we get rid of the extra 0000's.

Thanks.

Jerry


_________________________________________________________________
Join the world’s largest e-mail service with MSN Hotmail.
http://www.hotmail.com

Oracle LazyDBA home page