You can translate the question and the replies:

How to convert datetimestamp to utc format

one of field is havinf timstamp in another format but the requirement to convert it into utc format. we cant change view setting is there any way where we can change timestamp format to utc.
timestamp
user
04-07-2023 07:39:28 -0400
code

1 Answer

Hi, I’d use the AT TIME ZONE function that returns the timestamp passed as a parameter with its time zone changed to the time zone specified. This function takes a timestamp without a time zone, assigns the timezone specified converting it to a timestamptz and returns a TIMESTAMPTZ value. For example: `SELECT <timestamp_column> AT TIME ZONE 'UTC' from <view>;` For more information, you can refer to the section [Datetime Functions](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/functions/datetime_functions/datetime_functions) of the VirtualDataport VQL Guide. Hope this helps!
Denodo Team
05-07-2023 07:59:53 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here