[SalesForce] how to convert “04/09/2015T06:00:00.000Z” into apex datetime

How to convert this text "04/09/2015T06:00:00.000Z" into a valid apex datetime ?
where the time should be unmodified

Best Answer

I don't think you can convert it in one go. You should dissect the string and convert. Look at the following code it will do it :

    String d1 = '04/09/2015T06:00:00.000Z';
    list<String> d2 = d1.split('/');
    list<integer> timeComponent = new list<integer>();

    timeComponent.add(Integer.valueOf(d2[0]));
    timeComponent.add(Integer.valueOf(d2[1]));
    timeComponent.add(Integer.valueOf(d2[2].left(4)));

    String t = d2[2].substringBetween('T','.');

    list<String> time1 = t.split(':');
    timeComponent.add(Integer.valueOf(time1[0]));
    timeComponent.add(Integer.valueOf(time1[1]));
    timeComponent.add(Integer.valueOf(time1[2]));

    Datetime dt = Datetime.newInstance(timeComponent[2],
                                        timeComponent[1],
                                        timeComponent[0],
                                        timeComponent[3],
                                        timeComponent[4],
                                        timeComponent[5]);

Just try this out, it should work.

Related Solutions

[SalesForce] How to convert a text to dateTime

Map <String, Integer> monthNames = new Map <String, Integer> {'Jan'=>1, 'Feb'=>2, 'Mar'=>3, 'Apr'=>4, 'May'=>5, 'Jun'=>6, 'Jul'=>7, 'Aug'=>8, 'Sep'=>9, 'Oct'=>10, 'Nov'=>11, 'Dec'=>12};
List <String> stringParts = 'Wed Aug 07 04:30:00 GMT 2013'.split(' ');
List <String> timeParts = stringParts[3].split(':');

DateTime yourDateVariable = DateTime.newInstanceGmt(Integer.valueOf(stringParts[5]), monthNames.get(stringParts[1]), Integer.valueOf(stringParts[2]), Integer.valueOf(timeParts[0]), Integer.valueOf(timeParts[1]), Integer.valueOf(timeParts[2]));

[SalesForce] Datetime parsing

Here's an example from some code I used in a trigger on how to do this

StrtTmDt = sClsMnth + '/' + sClsDay + '/' + sClsYear + ' ' + strtTm;

So, in your case,

String date = ''; //would need to be formatted as 'dd/mm/yy'

String time = ''; //would need to be formatted as ' hh:mm aa` where aa is AM or PM

note the blank space between the ' and the hh. You need this separation. SF will automatically add :00 seconds for you so there's no need to add them unless you actually are recording seconds or microseconds for that matter.

If properly formatted as above, you could then do the following:

String dt = date + time;

DtTm = DateTime.parse(dt);

Best Answer

Related Solutions

[SalesForce] How to convert a text to dateTime

[SalesForce] Datetime parsing

Related Topic