I am trying to format a date such that..
- Timezone is UTC
- Be in a form SQLite can accept (e.g. YYYY-MM-DD HH:MM:SS).
The following is an example of the formatting method I am currently employing, it returns the last reported time of each computer.
(((year of it as string& "-" & month of it as two digits& "-" & day_of_month of it as two digits) of date ("ut" as time zone) of it& " " & time of time ("ut" as time zone) of it as string) of last report time of it)of(bes computers)
Note, the actual query has multiple items in the "of" clause making accessing "last report time of it" even more rebose.
Does anyone have formatting tips or suggestions? I can't believe this is the best way of doing it.