Re: how do I ge a list of date from a date ran...

Author Login • Post Reply

You can use simple range to do it:

def initialDate = Date.parse("dd/MM/yyyy", "01/01/2012")

def finalDate = Date.parse("dd/MM/yyyy", "15/01/2012")

def dateRange = (initialDate..finalDate)

println dateRange

"dateRange" will be an array with all dates between the two dates (inclusive).

you can iterate with:

dateRange.each { date ->

println date

}

and have the output:

Sun Jan 01 00:00:00 BRST 2012

Mon Jan 02 00:00:00 BRST 2012

Tue Jan 03 00:00:00 BRST 2012

Wed Jan 04 00:00:00 BRST 2012

Thu Jan 05 00:00:00 BRST 2012

Fri Jan 06 00:00:00 BRST 2012

Sat Jan 07 00:00:00 BRST 2012

Sun Jan 08 00:00:00 BRST 2012

Mon Jan 09 00:00:00 BRST 2012

Tue Jan 10 00:00:00 BRST 2012

Wed Jan 11 00:00:00 BRST 2012

Thu Jan 12 00:00:00 BRST 2012

Fri Jan 13 00:00:00 BRST 2012

Sat Jan 14 00:00:00 BRST 2012

Sun Jan 15 00:00:00 BRST 2012

[]s,

Lucas Teixeira

On Fri, Jan 27, 2012 at 12:40 AM, priyank15 <priyank.devurkar@gmail.com> wrote:

I have a simple query which get a list of all dates in a date range, and want
to implement it in groovy.

select
TO_DATE('01/23/2012','MM/DD/YYYY') + level -1
from
dual connect by level < (TO_DATE('02/07/2012','MM/DD/YYYY') -
TO_DATE('01/23/2012','MM/DD/YYYY'));

Result set is :

23-JAN-12
24-JAN-12
25-JAN-12
26-JAN-12
27-JAN-12
28-JAN-12
29-JAN-12
30-JAN-12
31-JAN-12
01-FEB-12
02-FEB-12
03-FEB-12
04-FEB-12
05-FEB-12

Can I do this using groovy or if not hibernate?

--
View this message in context: http://groovy.329449.n5.nabble.com/how-do-I-ge-a-list-of-date-from-a-date-range-using-groovy-or-hibernate-query-tp5434503p5434503.html
Sent from the groovy - user mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

http://xircles.codehaus.org/manage_email

Re: [groovy-user] how do I ge a list of date from a date range using
groovy or hibernate query

Lucas F. A. Teixeira

2012-01-27

Re: [groovy-user] how do I ge a list of date from a date range using groovy or hibernate query

Lucas F. A. Teixeira

2012-01-27

Re: [groovy-user] how do I ge a list of date from a date range using
groovy or hibernate query