Date type conversion

senthilmp · Post by **senthilmp** » Thu Oct 09, 2008 1:41 pm

Hi ,

I have a source file containing the date as

eg:

20080120(YYYYMMDD) and i want this to be tranformed into output target table in date format, pls help me out to do so.

Thanks,
Senthil

mandyli · Post by **mandyli** » Thu Oct 09, 2008 1:43 pm

Hi

What is your target database?

chulett · Post by **chulett** » Thu Oct 09, 2008 1:54 pm

What "date format" do you need? There's always an IConv/OConv pair but if your incoming format is consistent then substring should be fine. For example:

Code: Select all

YourField[1,4]:"-":YourField[5,2]:"-":YourField[7,2]

To change YYYYMMDD to YYYY-MM-DD.

senthilmp · Post by **senthilmp** » Sat Oct 11, 2008 10:37 am

mandyli wrote:Hi

What is your target database?

My target database is Oracle

senthilmp · Post by **senthilmp** » Sat Oct 11, 2008 10:44 am

chulett wrote:What "date format" do you need? There's always an IConv/OConv pair but if your incoming format is consistent then substring should be fine. For example:
Code: Select all
YourField[1,4]:"-&quo ...[/quote]

I need DD-MON-YYYY format ie (I am creating table through Datastage itself, using create table option)

chulett · Post by **chulett** » Sat Oct 11, 2008 12:53 pm

For Oracle you don't "need" any particular format, so long as the TO_DATE() mask matches your data.