How to convert string to date in talend

Use below expressions in any of the talend job flow to get the formated date output, Expression can be applied in tMap, tJava,tJavaflex,tJavaRow etc...

TalendDate.formatDate("hh:mm dd-MM-YY",TalendDate.parseDate("HHmmddMMyy",row1.newColumn))

Comments

Post a Comment

Popular posts from this blog

Most commonly used components in TALEND

Image
  The following is the list of widely used connectors and components for data integration in Talend Open Studio − tMysqlConnection  − Connects to MySQL database defined in the component. tMysqlInput  − Runs database query to read a database and extract fields (tables, views etc.) depending on the query. tMysqlOutput  − Used to write, update, modify data in a MySQL database. tFileInputDelimited  − Reads a delimited file row by row and divides them into separate fields and passes it to the next component. tFileInputExcel  − Reads an excel file row by row and divides them into separate fields and passes it to the next component. tFileList  − Gets all the files and directories from a given file mask pattern. tFileArchive  − Compresses a set of files or folders in to zip, gzip or tar.gz archive file. tRowGenerator  − Provides an editor where you can write functions or choose expressions to generate your sample data. tMsgBox  − Returns a dialo...
Read more

How to execute the Talend job in command line

 It is based on the version what we are using. Talend Open Studio does not allow you to build jobs from the command line, that's a feature of the enterprise edition of Talend which has a commandline module. Alternatively you can export the job and execute .bat file from windows systems, .sh file is from linux systems
Read more