month from date

[consulting]

Hi
I have date column like 20070203
20070912
........the format is yyyymmdd in text file i want to split month only ie 02
09...

How to achive it in parallel? what function should be used?


thanks
Balaji G

[Maveric]

From your examples i would assume that the input is always 8 characters long. So a simple substring like In.Col[5,2] in a transformer stage would do.

[ray.wurlod]

If you have a Date column is does NOT have a format: your Sequential File stage specifies the date format in the file and the import operator looks after it. If it's a Char or VarChar data type then the format is important.

There are date conversion functions both for the Modify stage and for the Transformer stage for extracting components from dates.

[consulting]

Thanks
In server we can use substring. How about in Px?

[priyadarshikunal]

Thanks
In server we can use substring. How about in Px?

you can use substring in PX too.

Code: Select all

datecolumn[5,6]

Regards,

[ray.wurlod]

ONLY if it is a string. If it is a date, you need to apply a date to string conversion function first.

There are other functions available that will extract date components directly from dates.