Converting string to date, than selecting between 2 dates not working?

[njdubois]

This works :

SELECT cast(STR_TO_DATE(Session_Date,'%m/%d/%Y') as date) as cur_date, Session_Date FROM `Call_Record` 

 

It returns a LOT of results.

 

But this doesn't:

SELECT cast(STR_TO_DATE(Session_Date,'%m/%d/%Y') as date) as cur_date, Session_Date FROM `Call_Record` WHERE 'cur_date' > "2011-02-01" and 'cur_date' < "2012-02-08"

 

It returns 0 results even though there are hundreds of dates that fall with in that range.

 

I originally had:

SELECT STR_TO_DATE(Session_Date,'%m/%d/%Y') as cur_date, Session_Date FROM `Call_Record`

 

But adding the WHERE returned 0 results, so I tried adding the cast stuff, and it still didn't work.

 

I have also tried using:

WHERE 'cur_date' between "2011-02-01" and "2012-02-08"

 

Any idea what I am doing wrong?

 

Thanks a million!

Nick

[Barand]

You can't use an alias in a where clause. You need to put the STR_TO_DATE() function again.

 

The "cast" not required.

[njdubois]

Thanks!

 

SELECT Session_Date FROM `Call_Record` WHERE STR_TO_DATE(Session_Date,'%m/%d/%Y')>'2013-01-01' AND STR_TO_DATE(Session_Date,'%m/%d/%Y')<'2013-01-10'

 

Worked perfectly!

 

Many thanks!!

Nick