Groovy

Get UTC now

println "-------------------------------------------------------------------"

import java.text.SimpleDateFormat

final SimpleDateFormat atomDefault = new SimpleDateFormat("yyyyMMdd HHmmss.SSS")
atomDefault.setTimeZone(TimeZone.getTimeZone("CET"))

final SimpleDateFormat utcISO = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'")
final SimpleDateFormat localISO = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSS")
//utcISO.setTimeZone(TimeZone.getTimeZone("GMT"));

String utcDateS = utcISO.format( new Date())
println "UTC -now() as String: $utcDateS"

Date dt = utcISO.parse( utcDateS)
println "UTC -now() as Date  : $dt"
println "---"

String atomTimeS = atomDefault.format( new Date())
println "ATOM-now   () as String: $atomTimeS"
Date atomTimeUTC = atomDefault.parse( atomTimeS)
println "ATOM-nowUTC() as Date  : $atomTimeUTC"

// it does formatting, only, no time-zone shift!!!
// Take a datetime from UTC time-zone and format it without 'Z'
atomTimeS = localISO.format( atomTimeUTC)
println "ATOM-nowUTC() as String: $atomTimeS"

println "---"

String inS = "2023-07-31T14:00:00Z"
Date   inDt =utcISO.parse( inS)
println "String: $inS"
println "--> dateTime: $inDt"
String result = localISO.format( inDt)
println "--> dString w/o Z: $result"

PASS result to the DB profile as Date/Time

Format d.profile to json

import java.text.SimpleDateFormat

final SimpleDateFormat atomDefault = new SimpleDateFormat("yyyyMMdd HHmmss.SSS")
atomDefault.setTimeZone(TimeZone.getTimeZone("CET")) // simulate ATOM time-zone

// Simulate a d.Profile with Date/Type
Date atomDateTimeField = atomDefault.parse( "20230728 142051.525")
println atomDateTimeField                   // Fri Jul 28 12:20:51 UTC 2023

final SimpleDateFormat utcISO = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss'Z'")
utcISO.setTimeZone(TimeZone.getTimeZone("CET")) 	// put formatter on the same time-zone as atomDefault
println utcISO.format( atomDateTimeField)

Log Datetime

IN_S : Character
IN_DT: Date/Time

import com.boomi.execution.ExecutionUtil;
_logger = ExecutionUtil.getBaseLogger()
_logger.info('IN_S: ' + IN_S )
_logger.info('IN_DT:' + IN_DT)