Hi Andrew,
I recently worked with the VFP 9 and Oracel 9.2 and Oracle 10g with timestamp.
You dont have to use TO_CHAR(), VFP retrieves data perfectly.
Select dbtimezone from dual; -> Would show the timezone
Show parameter NLS; -> would show all NLS parameter and any formats they are using.
Try changing NLS_DATE_FORMAT to the one showed.
nls_date_format string DD-MON-YYYY HH24:MI:SS
See the formating of the mentioned below parameters on google(i dont have 9.02 to check whether they exist in that version)
nls_time_tz_format
nls_timestamp_format
nls_timestamp_tz_format
I hope this could help.
>Has anyone had any experience with retrieving Oracle TIMESTAMP WITH LOCAL TIME ZONE data types via ODBC or OLE DB? I realise I can wrap these dates with the Oracle function TO_CHAR(), but this would mean we'd have to change quite a bit of code. We currently use SQL Pass Through and Oracle ODBC driver 9.02.00.54. When we try to access the TIME ZONE fields, without wrapping with TO_CHAR(), it actually crashes Foxpro.