#1 2009-03-19 11:51:42

srinivasan
Member
Registered: 2009-03-06
Posts: 158

getdatepart logic

hai,

  I have a date Column,I need a  date column split to date individual column,month individual column,year individual column,


  Which function i should use?




Thanx,

Offline

#2 2009-03-19 14:34:51

shong
Talend team
Registered: 2007-08-29
Posts: 10305
Website

Re: getdatepart logic

Hello

It's easy to implement your request in Talend. Can you show us an example of your date and what are your expected result?

Best regards

          shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

#3 2009-03-19 21:49:26

Volker Brehm
Member
Registered: 2007-04-03
Posts: 1139
Website

Re: getdatepart logic

Hi,

do you use Perl or Java code generation? And if Java is it a Date data type or a String with Date inside?

If Java with a Date type the following information will help you:
[Forum, post 22716 by Volker Brehm in topic 5853] get the year of a date
and
SUB Java API 1.5: java.util.Calendar

Bye
Volker

Offline

#4 2009-03-24 14:22:39

srinivasan
Member
Registered: 2009-03-06
Posts: 158

Re: getdatepart logic

hi shong,
              Thanx,  I have a date column format this,

                                                        dd/mon/yyyy hh:mm:ss

                                       
                                                        i) date individual column
                                                        ii) Month individual column
                                                        iii) year individual column

  How Should i do that?

Offline

Board footer

Powered by FluxBB