Re: to_date format

From: MattJ83 <mattjones_at_hotmail.co.uk>
Date: 19 Sep 2006 05:46:52 -0700
Message-ID: <1158670012.510999.91240@k70g2000cwa.googlegroups.com>

> >
>
> Hi Matt,
>
> if your filename consists always of the date followed by an underscore
> followed by something else, then you can just take the substring up to
> the first unterscore:
> TO_DATE(SUBSTR('$filename',1,INSTR('$filename','_')-1),'YYYYMMDDHH24')
>
>
> hth
> Peter

Thats great thanks Peter.

So that works - is there a way as easy as that for grabbing the 103 part - or is it best to split the filename up to get this? Received on Tue Sep 19 2006 - 07:46:52 CDT