timestored / pulseui

Real-time interactive database applications
https://www.timestored.com/pulse/
Other
81 stars 10 forks source link

Support more time formats in BabelDB? #301

Open ryanhamilton opened 4 months ago

ryanhamilton commented 4 months ago

user-site BabelDB supports some datetime formats (these are not documented well). Some users seem to be trying to parse more time formats. Should Pulse support these? (timezones?)

e.g. this query actually fails to display data in table:

QUERY_DATA('21:41:57|2
22:41:57|13
23:41:57|6')

These work:

QUERY_DATA('1 | 00:00:00 | 0 | 2023-07-05 | 00:00:00 | 00:00:00 | 2023-07-05 00:00:00.0 | 2023-07-05 00:00:00.0
1 | 00:01:00 | 1 | 2023-07-06 | 00:00:01 | 00:00:00 | 2023-07-05 00:01:00.0 | 2023-07-05 00:01:00.0')

Image