Try:

substr(ODR_TM,9,8)

j f wrote:

> 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 documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page