How to use a function in SQL query that convert the time into local time time-zone?
Question

Hi Community,

I need to convert the time into localtime in SQL query. What kind of function/method I can use in SQL query which convert the time into local time.

Check the image for the reference.

Help me into that. It will be appreciable.

img.PNG

Hi Prince,

It will automatically be converted during runtime when using mobile or reactive.

When the time retrieved from the server/database is 08:00:00, it would automatically be converted when displayed depending on the timezone set on the device. 

This screenshot came from this documentation: Available Data Types - OutSystems

But if you want to convert it when testing an sql, I suggest to determine the timezone of the server first and have an input parameter in your sql that accepts integer which represents the timezone that you want to adjust it with then use some sql/oracle syntax that adjust time. Sample here

Hope this helps

Cheers

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.