There are some functions that may help, if you need to use them in calculations:
sorry, hit send too soon!
1. in addition to the functions, do you need to Trim()? some columns may have spaces padding them. click into the 'text' field that would be the PostGreSQL timestamp and if the cursor goes past the values, there may be invisible characters
2. ODBC/SQL dates are typically YYYY-MM-DD format.
2. Did you try VALUES(4,?)