Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

mysql - get time interval

 
ian dwyer
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hello - this is probably pretty simple, but i was wondering if anyone had seen any examples of how to select something from a database based on a time interval.

for example, i have a number of records in a database, and I want to be able to pull all the ones out that have been created, say, less than one hour from the present time.

what is the best time/date format to stamp these things and what are the comparison methods like?

thanks!
 
Sonny Gill
Ranch Hand
Posts: 1211
IntelliJ IDE Mac
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Ian, welcome to JavaRanch.

This depends on the database you are using, and whether it supports arithmatic operators on date/time values, or has special methods to use with data/time.

In Oracle, you can just subtract two Dates, and it gives you the number of days(or the fraction of a day) between the two, which you can use in specifying your conditions.

The best place to start is the documentation for the database you are using.

Cheers
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic