File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Working with dates Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Working with dates" Watch "Working with dates" New topic

Working with dates

Drew Lane
Ranch Hand

Joined: May 13, 2001
Posts: 296
Does anyone have any suggestions for working with dates that will be stored in a MySQL database?
For example, I want to create a subscription service and store an expiration date in the database.
Should I create the date in Java and then store it in the database or should I have mySQL create the date for me (if that's possible)?
I suppose I'm going to have to convert the date back to a Java object in order to work with it, right?
Any thoughts?
Peter Straw
Ranch Hand

Joined: Jan 08, 2002
Posts: 79
You can use the timestamp data type, I found this at
The TIMESTAMP column type provides a type that you can use to automatically mark INSERT or UPDATE operations with the current date and time.
I agree. Here's the link:
subject: Working with dates
It's not a secret anymore!