Set Local Timezone vRA/vRO 8.x or Convert in Workflow

[hawks76]

I'm comparing 2 dates, one from SQL table that is local time and other is current date in vRO workflow.  Need to either set timezone in vRO so that it matches local time or be able to convert time stamps to have same timezone, whether UTC or local.  Google hasn't turned up much.  found an article to set timezone at ssh command line, but that didn't make a difference.

[xian_]

some possible solutions: Solved: Re: Convert dates in embedded vRO 8 with offset. ... - VMware Technology Network VMTN

[hawks76]

Wound up using SQL query to convert it.  Posting in case anyone else may benefit from it.

SELECT CONVERT(DATETIME,(Select TOP 1 datetimecolumename from dbtablename where columntofilteron = 'filter' order by coloumntosorton desc) AT TIME ZONE 'Central Standard Time' AT TIME ZONE 'UTC') as 'returnedcolumnUTC'

I use TOP 1 and order by because of possible records and needing most recent record based on a specific column.