3 ms·
And critical! Being able to snag a timespan of data, with point in time for records is the majority of what business users want. How this works usually depends
by nabilhat 6y ago
And critical! Being able to snag a timespan of data, with point in time for records is the majority of what business users want.
How this works usually depends on your data's provenance. Databases get built with lots of different and variously compatible definitions of "correct", sometimes because RDBMS date and time types are inconsistent, but usually during development. Not all of those definitions have a clean path to UTC offset, for example, if you're comparing data from different time zones.
If someone said they'd made a one size fits all query engine that will talk to any arbitrary database from a range of RDBMS and handle date/time consistently and reliably, I'd be skeptical. Maybe if it's operated by someone who knows what they're doing, but that's not exactly the target audience for natural language SQL queries.