• Post Reply Bookmark Topic Watch Topic
  • New Topic

Timestamp problem

 
Tony Evans
Ranch Hand
Posts: 598
1
  • 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
  • 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.
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!