topic Re: Converting a date and time string to a date format in Talend Studio

Converting a date and time string to a date format

Anonymous — Sat, 16 Nov 2024 04:05:35 GMT

I have a csv source file where the date coming in is a string format: 4/26/2013 11:07:05 PM

I need to convert this to a date format or 2013-04-26

I can't seem to get the basic functions to work. Do I need to parse out the 'PM' first?

Re: Converting a date and time string to a date format

Anonymous — Mon, 18 Nov 2019 20:25:41 GMT

This should work

SimpleDateFormat sdf = new SimpleDateFormat("M/dd/yyyy hh:mm:ss a");
Date d = sdf.parse("4/26/2013 11:07:05 PM");
sdf.applyPattern("yyyy-MM-dd");
String newDateString = sdf.format(d); //2013-04-26

Re: Converting a date and time string to a date format

Anonymous — Mon, 18 Nov 2019 22:00:39 GMT

I was originally trying to do this in a tMap expression. Would I use tJava to execute the script provided?

Re: Converting a date and time string to a date format

Anonymous — Tue, 19 Nov 2019 01:43:57 GMT

Hi
You can call the built-in function to do it on tMap, eg:
TalendDate.parseDate("M/dd/yyyy hh:mm:ss a", row1.columnName)

Regards
Shong