topic Re: Simba ODBC datetime with millisecond overflows in Data Engineering

Simba ODBC datetime with millisecond overflows

158808 — Sun, 03 Jul 2022 14:49:12 GMT

Hello,

Using odbc 2.6.24.1041-2 for Linux, when inserting rows with milliseconds precision date (e.g. 2022-07-03 13:57:48.500) precision I get:

2022/07/03 14:41:19 SQLExecute: {22008} [Simba][Support] (40520) Datetime field overflow resulting from invalid datetime.

With Scala works fine:

spark.sql("INSERT INTO ... () VALUES ('2022-07-03 13:57:48.500')");

Is there a way to add millisecond precision with ODBC (or JDBC which I've not tried yet)?

Thank you,

Nikos

Re: Simba ODBC datetime with millisecond overflows

Prabakar — Thu, 07 Jul 2022 10:55:43 GMT

Hi @Nikos Mitsis have you tried `CAST()`

Re: Simba ODBC datetime with millisecond overflows

158808 — Fri, 08 Jul 2022 06:54:54 GMT

I was passing a string (e.g. '2022-07-03 13:57:48.500') to the Golang SQL driver which is not working if the ms part is specified, but otherwise it works (e.g. '2022-07-03 13:57:48'). Passing a native Golang time.Time seems to work for timestamps with a ms part too.

Thank you for your help.