Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
tom_abramov
Level V

SQL datetime column is imported as missing values in JMP

Hi,

I'm running a simple query with Query Builder on SQL data set.

There is a Datetime column in SQL with datetime format, with values in all rows.

After importing the data to JMP, all the column of the datetime gets missing values.

On the other hand, if I filter by that datetime column in Query Builder, the filter works fine.

Any idea why such a thing can occur?

Thank you.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
tom_abramov
Level V

Re: SQL datetime column is imported as missing values in JMP

The solution for me was disabling an option

"Use regional settings when outputting currency, numbers, dates and times"

in ODBC connection configuration.

View solution in original post

4 REPLIES 4
Highlighted
Craige_Hales
Staff (Retired)

Re: SQL datetime column is imported as missing values in JMP

The filtering happens on the database server. When you say it works fine, do you mean JMP displays non-missing datetime values for the filtered subset? @Eric_Hill 

Craige
Highlighted
tom_abramov
Level V

Re: SQL datetime column is imported as missing values in JMP

The filtering works fine (I get a portion of SQL data table in JMP) but the dates after importing are missing.

Highlighted
Craige_Hales
Staff (Retired)

Re: SQL datetime column is imported as missing values in JMP

Highlighted
tom_abramov
Level V

Re: SQL datetime column is imported as missing values in JMP

The solution for me was disabling an option

"Use regional settings when outputting currency, numbers, dates and times"

in ODBC connection configuration.

View solution in original post

Article Labels

    There are no labels assigned to this post.