DateTime with timezone and milliseconds
1223
Views
5
Comments
New
Backend

There are some requests regards Time related actions should support timezones, but I think the changes should be more radical, the DateTime date type itself should be updated in two ways:

  • Support Offset or Timezone information
  • Support Milliseconds for more accuracy
Changed the category to
Backend
Merged this idea with 'Millisecond support for DateTime' (created on 21 Oct 2020 21:34:08 by Greg Whitten)

Have support for milliseconds on the DateTime datatype, add the corresponding built-in functions for AddMilliseconds, DiffMilliseconds, etc, and add support to create DateTimeFormat strings that display milliseconds.



This comment was:
- originally posted on idea 'Millisecond support for DateTime' (created on 21 Oct 2020 by Greg Whitten)
- merged to idea 'DateTime with timezone and milliseconds' on 23 Oct 2020 03:36:24 by Justin James
Merged this idea with 'Datetime in milliseconds' (created on 07 May 2021 17:05:33 by Carlos Ioliva)

Built-in function or action to get the current datetime in milliseconds.

Useful for logging, audit and to create simple unique keys.



This comment was:
- originally posted on idea 'Datetime in milliseconds' (created on 07 May 2021 by Carlos Ioliva)
- merged to idea 'DateTime with timezone and milliseconds' on 10 May 2021 15:06:58 by Justin James