Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Sql TIME data type is not fully supported by unixODBC driver

Hi!

SQL standard defines data type TIME with precision, i.e. "HH:MM:SS.MSEC" , but unixODBC driver do not supports in floating point for TIME.

isql
[email protected]:~$ isql Vertica
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> select '13:14:15.161718'::TIME;
+---------+
| ?column?|
+---------+
| 13:14:15|
+---------+

Looks like ODBC isn't supported (sorry, but its very hard to call it as "supported"):
  • no support for all data types (for Python its even worst - no support for intervals)
  • no support for profiling (you have to do some workaround to get query profiled via connectivity drivers)
  • no driver support for special Vertica features
  • can't process TIME ZONE because Vertica converts all to UTC and returns incorrect results (incorrect time zone).
No, it isn't calls as "protocol support".

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.