Linker IT Software
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Oracle timestamp support (Read 1967 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
Oracle timestamp support
16.10.09 at 14:43:37
Oracle timestamp support
Does SQL*XL support the Oracle timestamp data type?

Yes it does. You can e.g. run the following command:
select current_timestamp from dual;
ODBC drivers seem to give problems but you can always to_char the timestamp:
select to_char(current_timestamp) from dual;
Other commands that involve a timestamp:
select cast( sysdate as timestamp) from dual;
See also:
Support for Oracle's timestamp data type
Unspecified error, timestamp, ODBC Oracle
Back to top
« Last Edit: 26.10.12 at 14:10:30 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1