Skip to main content

system.kanoa.utilities.convertDatesToString(datesIn:, deviceUTCOffSetMins)

When passing a date to a stored procedure, it needs to be converted to the timezone of the SQL Server We are assuming here that the SQL Server is in the same time zone as the gateway server We adjust the passed in dates to the servers timezone and then return it as a string before passing it to the stored procedure

Parameters​

datesIn: list[date]: list of dates to be converted i.e [startDate, endDate]
deviceUTCOffSetMins Integer: Client offset minutes

Returns​

datesOut List of Strings Converted date strings

Example​

startDate = system.date.parse("2025-11-01 00:00:00")
endDate = system.date.parse("2025-11-01 00:00:00")
print system.kanoa.utilities.convertDatesToString([startDate, endDate], -420)
>>>
[u'2025-10-31 17:00:00', u'2025-10-31 17:00:00']