WinSQL » Knowledge base

Document information

Document ID:1296
Subject:Using timestamp data type in Oracle
Creation date:4/14/10 5:20 PM
Last modified on:4/14/10 5:31 PM


Timestamps in Oracle and ODBC

The ODBC driver for Oracle does not support TimeStamp data type. Click here for more information. This prevents users from submitting a query like:


SELECT CURRENT_TIMESTAMP FROM dual


Trying to submit this query typically results in an error like:






Workaround

As a workaround try use the WinSQL Oracle Wire Protocol driver that comes with WinSQL. This driver has the ability to bind a TimeStamp data type to a DATE type and can therefore, display the results correctly.

Following steps demonstrates how to accomplish this task.
  • Create a new ODBC DSN using WinSQL Oracle Wire Protocol Driver. Click here if you need help
  • Once the DNS is created, click on the Advanced tab and select Enable TimeStamp with Timezone






Add a comment to this document

Do you have a helpful tip related to this document that you'd like to share with other users? Please add it below. Your name and tip will appear at the end of the document text.
Your name:
Your email:
Hide my email address
Verification code:
Enter the verification code you see above more submitting your tip
Tip:Please limit tips to 1000 characters

Navigation

Social Media

Powered by 10MinutesWeb.com