how to split day month year from a date format

Seven Stars

how to split day month year from a date format

hello,

i have a birth_date column '1962-02-19 00:00:00'  "yyyy-MM-dd" format

i want to split birthday-month-year and load it to three different database table.

 

please help me out

 

Thanks & regards

Manish

Forteen Stars TRF
Forteen Stars

Re: how to split day month year from a date format

TalendDate.getPartOfDate

TRF
Nine Stars

Re: how to split day month year from a date format

You could use tExtractRegexFields to split your input data into three parts.

Something like this - 

tFixedFlowInput-5.JPG

And have your regular expression defined as -

"([0-9]*)-([0-9]*)-([0-9]*)"

and the schema as -

tExtractRegexFields-1.JPG

 

Once you have done with your data split then you could have your database output defined accordingly.

Thirteen Stars

Re: how to split day month year from a date format

@vitspltalend,please find below tMap configuration,you can implement in this way also.Untitled.png

Manohar B
Thirteen Stars

Re: how to split day month year from a date format

you can convert belo way also.

Untitled.png

Manohar B