How do you get the date/time range for "today" using the Joda date/time library in Java?

java datetime jodatime
Morris picture Morris · Jun 29, 2011 · Viewed 27k times · Source

Assuming this is how you get the current time in Joda time:

DateTime now = new DateTime();

How do you calculate values for the variables dateTimeAtStartOfToday and dateTimeAtEndOfToday?

What I'm trying to do is generate some SQL to do a lookup of all transactions that have occurred between the startOfToday and endOfToday.

Answer

Jon Skeet picture Jon Skeet · Jun 29, 2011

I would use:

LocalDate today = now.toLocalDate();
LocalDate tomorrow = today.plusDays(1);

DateTime startOfToday = today.toDateTimeAtStartOfDay(now.getZone());
DateTime startOfTomorrow = tomorrow.toDateTimeAtStartOfDay(now.getZone());

Then check if startOfToday <= time < startOfTomorrow for any particular time.

Of course, it partly depends on exactly what's stored in the database - and what time zone you're interested in.

Related questions

Converting a date string to a DateTime object using Joda Time library

I have a date as a string in the following format "04/02/2011 20:27:05". I am using Joda-Time library and would like to convert it to DateTime object. I did: DateTime dt = new DateTime("04/02/2011 20:27:05") But I'm getting the following error : Invalid format: "04/02/2011 14:42:17" is …

Read More
Convert from java.util.date to JodaTime

I want to convert a java.util.Date to JodaTime so as to carry out subtractions between dates. Is there a good concise way to convert from Date to JodaTime?

Read More
Parse Date String to Some Java Object

I am working in a project that reads files and processes data. There I got to work with dates for example: 2012-01-10 23:13:26 January 13, 2012 I found the package Joda, kinda interesting package but don't know if it is the easiest …

Read More