do we have any time conversation UTC to AEST functions available in outsystems?(it should work for daylight saving time also)
Hi, I know outsystems storing date is UTC time zone, and application converting date and timer as per the client time Zone, that's good, actually while downloading the data from SQL sandbox, I want a convert dates into AEST (since by default its not happening)
While downloading the data from SQL in AEST format you can simply make an Advanced SQL query
'SELECT
Column1,
Column2,
CASE
WHEN YourUtcDateColumn BETWEEN '2024-10-06T02:00:00Z' AND '2025-04-06T03:00:00Z' THEN DATEADD(HOUR, 11, YourUtcDateColumn)
ELSE DATEADD(HOUR, 10, YourUtcDateColumn)
END AS YourDateInAEST
FROM
Table '
Hope this will help you
Thanks...
OutSystems does not provide a built-in function to directly convert UTC to AEST with consideration for daylight saving time. However, you can achieve this by using custom logic to handle the conversion.
Hi @Priya Naveen
There is no builtin function to calculate the timezone.
TimeZones Converter - Overview (O11) | OutSystems
I hope this forge component will help you. or
You may add custom logic like this
var aestOffsetHours = 10; // Calculate offset in minutes (considering standard time only) var aestOffsetMinutes = aestOffsetHours * 60; // Adjust UTC time based on the offset (add for AEST) var aestDateTime = DateTimeAddMinutes(utcDateTime, aestOffsetMinutes);
Regards
Karnika.K
Hello @Priya Naveen
Yes we have a time conversation UTC to AEST functions available in outsystems
just simply use this sql
DATEADD(HOUR, 10, YourUtcDateColumn) AS YourDateInAEST
YourTable '
thanks, it will work now, but when it comes to daylight saving time 10 hours may change, in that scenario