Get UTC Time from Local Timestamp

November 16, 201114 yr

... feel free to report bugs & errors


// USAGE : LocalTimeStampToUTC ( fm_TimeStamp ; fm_TimeStampDateFormat ; fm_UtcOutputPattern )

// 20111115 clem

// version 1.2

//

// fm_TimeStampDateFormat => 1 = dd/MM/yyyy; 2 = MM/dd/yyyy; 3 = yyyy/MM/dd

// fm_UtcOutputPattern => see http://download.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html

//

// EXAMPLE = LocalTimeStampToUTC ( 01/01/2011 00:07:20 ; 1 ; "dd/MM/yyyy HH:mm:ss" ) [ my machine is located in Time Zone GMT + 1 ]

// RESULT => 31/12/2010 23:07:20



import java.text.SimpleDateFormat

import static java.util.Calendar.*



if (fm_TimeStamp && fm_UtcOutputPattern ){



    arrTxt = fm_TimeStamp.split(/[^0-9]/)

    def arrInt = []

    arrTxt.each{ arrInt.add(it as Integer)}



    def dateMap = [:]

    tsdf = ! fm_TimeStampDateFormat ? 1 : fm_TimeStampDateFormat as Integer

    switch ( tsdf ) {

	    case 2: dateMap = [y:arrInt[2], m:arrInt[0], d:arrInt[1]]; break;

	    case 3: dateMap = [y:arrInt[0], m:arrInt[1], d:arrInt[2]]; break;

	    default: dateMap = [y:arrInt[2], m:arrInt[1], d:arrInt[0]]

    }

    def timeMap = [h: arrInt[3], mn: arrInt[4], s: arrInt[5]]

    def tsMap = dateMap += timeMap



    // Month value is 0-based. e.g., 0 for January.

    def localCal = new GregorianCalendar()

    localCal.with{

	    set YEAR, tsMap["y"]

	    set MONTH, tsMap["m"] - 1

	    set DAY_OF_MONTH, tsMap["d"]

	    set HOUR_OF_DAY, tsMap["h"]

	    set MINUTE, tsMap["mn"]

	    set SECOND, tsMap["s"]

    }



    def utcCal = new GregorianCalendar(TimeZone.getTimeZone("GMT"))

    utcCal.timeInMillis = localCal.timeInMillis



    year = utcCal.get(YEAR)

    month = utcCal.get(MONTH)

    day = utcCal.get(DAY_OF_MONTH)



    h = utcCal.get(HOUR)

    h = ! utcCal.get(AM_PM) && ! fm_TimeStamp.toUpperCase().contains('PM') ? h : h + 12

    m = utcCal.get(MINUTE)

    s = utcCal.get(SECOND)



    def sdf = new SimpleDateFormat( fm_UtcOutputPattern )

    def cal = new GregorianCalendar(year, month, day, h, m, s)



    return sdf.format(cal.time)

}

see "Date & Time patterns" from the SimpleDateFormat class

Edited November 18, 201114 yr by clemhoff