Re: I have a sample dataset column into this format '2015-01-01' I want to re retrieve theose year whose months are June. What will be the query??
As Sunny Mentioned the month() function should help you achieve what you are looking for. In addition to that, make use of a master calender and other date functions to simplyfy your front end calculations like:
inYeartoDate() etc.... Check the script manual for detailed info on all the date functions.