Time zone issue

[vomikan]

#5530 (comment)

The time values in the CHECKINGACCOUNT_V1 table are stored in UTC.

And the customized values are saved 1:1

[n-stein]

I commented on the other issue, but SQLite can do the UTC conversion for you:

select * from CHECKINGACCOUNT_V1 c
where c.LASTUPDATEDTIME >= datetime('&single_date'||'T'||'&single_time', 'UTC');

[n-stein]

The UDF fields are user-managed and not system-managed so I think we need to keep them 1:1.