Date type and mySQL

Thread view:

jackie - 31 May 2004 05:11 GMT

I am using mySQL and connectorJ.

As I know there are at least 3 types suitable for date storage in JAVA.
java.sql.Date
java.sql.Time
java.sqlTimestamp

If the data type in mySQL is Datetime or Timestamp, which Java type is
better ?

Reply to this Message

Chris Smith - 31 May 2004 15:30 GMT

> I am using mySQL and connectorJ.
>
[quoted text clipped - 5 lines]
> If the data type in mySQL is Datetime or Timestamp, which Java type is
> better ?

All three of the java.sql date types are best used as adapters to use
existing instances of java.util.Date in your data layer. For that
purpose, java.sql.Timestamp best corresponds with MySQL's datetime and
timestamp fields.

Outside your data layer, just use instances of java.util.Date, rather
than spreading the JDBC API through your application code. It's cheap
enough to wrap them when you get to the database access.

Signature

www.designacourse.com
The Easiest Way to Train Anyone... Anywhere.

Chris Smith - Lead Software Developer/Technical Trainer
MindIQ Corporation

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...