nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SQL datetime column is imported as missing values in JMP

tom_abramov

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.

Accepted answers

tom_abramov

The solution for me was disabling an option

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

in ODBC connection configuration.

All comments

Craige_Hales

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

tom_abramov

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

Craige_Hales

Maybe one of these

tom_abramov

The solution for me was disabling an option

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

in ODBC connection configuration.