Main Board > ODBC

ODBC Date Issue

<< < (3/3)

Devon Austen:
The PxPlus SQL ODBC driver supports that date class.

When using SQL though you use the SQL date format (YYYY-MM-DD) the driver does the conversion to how the date is stored in your file. So assuming your data dictionary has set the date class for the field correctly if you do a SQL query like

SELECT * FROM myTable WHERE datefld > '2022-09-01'

you should get what you want.

Navigation

[0] Message Index

[*] Previous page