Simba ODBC datetime with millisecond overflows

158808
New Contributor II

‎07-03-2022 07:49 AM

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

0 Kudos

Prabakar
Databricks Employee
Databricks Employee

‎07-07-2022 03:55 AM

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

158808
New Contributor II

‎07-07-2022 11:54 PM

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.