Hi,
It is possible to convert a datetime value into the timestamp with time zone format using the** to_timestampz** function.
The syntax is,
`TO_TIMESTAMPTZ( <timestamptz pattern:text>, <value:text> [, <language:text> ] ):timestamptz`
where **timestamptz pattern** is required in a pattern describing the date and time format of value, following the syntax defined by Java in the class java.text.SimpleDataFormat.
You can also use the [Date time processing functions](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/appendix/syntax_of_condition_functions/date_processing_functions#to-timestamptz) of the Virtual DataPort to achieve your use case.
You can also convert/ cast the value to an EPOC value and the convert it to timestamp format in the Virtual DataPort. Please refer to this related [Community question](https://community.denodo.com/answers/question/details?questionId=9060g000000TQzqAAG&title=Converting+timestampz+to+epoch+time).
Hope this helps!
