Set the DB type. Default DBType is ACCESS.
Obj.dbType=="ACCESS(def)|SQL|ORACLE|SYBASE|FOXPRO|EXCEL|TXT|DB2"
X.dbDBType="SQL"
X.dbDBType="ORACLE"
| DB Type |
Left |
Right |
Default Date Format |
| ACCESSSQL |
' |
' |
[MM/DD/YYYY HH:MM:SS] |
| ACCESS |
# |
# |
[MM/DD/YYYY HH:MM:SS] |
| SQL, SQL65 |
' |
' |
[MM/DD/YY HH:MM:SS] |
| MYSQL |
' |
' |
[YYYY-MM-DD HH:MM:SS] |
| SYBASE |
' |
' |
[YYYY/MM/DD HH:MM:SS]' |
| ORACLE |
' |
' |
TO_DATE('[DD-MMM-YYYY HH:MM:SS]','DD-MON-YYYY
HH24:MI:SS') |
| DB2 |
' |
' |
[MM/DD/YY HH:MM:SS] |
| FOXPRO |
{ |
} |
MM/DD/YY HH:MM:SS |
| EXCEL", "TEXT", "TXT" |
|
|
MM/DD/YY |