Between Dates

Brad Weiland

Hi,

I'm new to SQL and I have the following quesiton.

I have table of data as follows:

Date
31-01-2007
12-31-2007
31-01-2008
31-12-2008

If a want to create an if statement that says if date falls between 31-01-2007 and 12-31-2007 put Year 1, if date falls between 31-01-2008 and 31-12-2008 put Year 2, etc.

Do I use the following formula:

CASE When Date >=31-01-2007 AND <=12-31-2007 THEN "Year 1,

Atli

Hi.

You could use the BETWEEN ... AND syntax. Like:

Expand|Select|Wrap|Line Numbers

SELECT 2 BETWEEN 1 AND 3;

Replacing the numbers with dates.

Brad Weiland

I figured it out the answer to my question

Expand|Select|Wrap|Line Numbers

 
CASE WHEN Invoice Date BETWEEN '01-APR-2005' AND '31-MAR-2006' THEN '05-06' ELSE CASE WHEN Invoice Date BETWEEN '01-APR-2006' AND '31-MAR-2007' THEN '06-07' ELSE '0' END END

Between Dates

re: Between Dates

re: Between Dates

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about