File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Timestamp problem

 
Tony Evans
Ranch Hand
Posts: 597
1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am building the Dukes bank example using an Oracle Databsae.

In the Database they have a datatype TIMESTAMP.

In the code they have this data set as DATE. this is causing an error to be thrown as invalid column type.

I guess one way would be to change DATE to TIMESTAMP

Is there another way round this.

Thanks for any help Tony
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Tony,

I guess one way would be to change DATE to TIMESTAMP

Don't you mean: change TIMESTAMP to DATE?
Oracle does also have a DATE data-type -- which contains a "date" part and a "time" part. The TIMESTAMP type is new in Oracle 9i and adds a "fraction-of-second" part to the "date" and "time" parts. So go ahead, change your database column's data-type from TIMESTAMP to DATE.

Good Luck,
Avi.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic