Quarter Time Range Problem


(vijuitech) #1

Hi,
I am using DateHistogram Facet for finding the Date Range. In
my application I need to get the Quarter Value similar

SELECT QUARTER(Created_DT) FROM TableName;

In MySQL it is taking

January to March as Quarter 1

April to June as Quarter 2

July to September as Quarter 3

October to December as Quarter 4

Is there any method in elasticsearch to find the Quarter Value
similar to MySql?

Thanks in Advance!

Cheers!

George


(Shay Banon) #2

There isn't one, but you can do a date histogram facet on months and
aggregate the values to quarters yourself.

On Wed, Apr 18, 2012 at 4:32 PM, George Viju vijuitech@gmail.com wrote:

Hi,
I am using DateHistogram Facet for finding the Date Range. In
my application I need to get the Quarter Value similar

SELECT QUARTER(Created_DT) FROM TableName;

In MySQL it is taking

January to March as Quarter 1

April to June as Quarter 2

July to September as Quarter 3

October to December as Quarter 4

Is there any method in elasticsearch to find the Quarter Value
similar to MySql?

Thanks in Advance!

Cheers!

George


(vijuitech) #3

Thank You Shay!

Cheers!

George

On Apr 19, 7:41 pm, Shay Banon kim...@gmail.com wrote:

There isn't one, but you can do a date histogram facet on months and
aggregate the values to quarters yourself.

On Wed, Apr 18, 2012 at 4:32 PM, George Viju vijuit...@gmail.com wrote:

Hi,
I am using DateHistogram Facet for finding the Date Range. In
my application I need to get the Quarter Value similar

SELECT QUARTER(Created_DT) FROM TableName;

In MySQL it is taking

January to March as Quarter 1

April to June as Quarter 2

July to September as Quarter 3

October to December as Quarter 4

Is there any method in elasticsearch to find the Quarter Value
similar to MySql?

Thanks in Advance!

Cheers!

George


(system) #4