This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes Data Type Date Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Data Type Date" Watch "Data Type Date" New topic

Data Type Date

Patricia Samuel
Ranch Hand

Joined: Sep 12, 2007
Posts: 300
Hi Experts,

I am working on creating table structure for my application. There are some date fields that would not have time with them in the data. I want to ask you guys whether we should take Date date type for this type of column or we should prefer Varchar2.

Thanks for all your help in advance!!!

Warm Regards,
Patricia samuel
Agador Paloi
Ranch Hand

Joined: Jan 24, 2006
Posts: 118
Always use Date for dates regardless if you are interested in the time or not.

I agree. Here's the link:
subject: Data Type Date
Similar Threads
Simple Hibernate Help (Im Noob)
Passing specific format date to callable statement
How to define custom data type in Schema
Websphere and Date fields in Oracle
JDBC Problem with Date insertion