[SalesForce] How to convert a text to dateTime

How can i convert a string like this Wed Aug 07 04:30:00 GMT 2013 to a dateTime value?

Best Answer

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]));

Related Solutions

[SalesForce] Convert Datetime of one Timezone to Datetime of another TimeZone

Your approach is perfect to convert values according to specific Timezone as:

System.debug(' Current Time is '+ DateTime.now() );
System.debug(' Converted Time to PST is ' +
                  DateTime.now().format('MM/dd/yyyy HH:mm:ss',
                  'America/Los_Angeles')
             );

However you can convertTimezone SOQL function in your query. It converts DateTime field to the user’s time zone.:

Case c = [SELECT Id, convertTimezone(SlaStartDate) FROM Case WHERE Id='caseId'];

[SalesForce] Convert String DateTime to User local DateTime

You can use DateTime methods to convert the time to user's Timezone.

String strDt = DateTime.now().format('MM/dd/yyyy HH:mm:ss', 'America/Los_Angels');

Best Answer

Related Solutions

[SalesForce] Convert Datetime of one Timezone to Datetime of another TimeZone

[SalesForce] Convert String DateTime to User local DateTime

Related Topic