@erictgrubaugh The problem is even if I use

format.parse

and

format.format

to get the time with the current account or company preferences time zone it does not work because the STRING coming from the Query is wrong, the value stored in the field is there and the string returned by a search or query should not change/alter that value.