problem in Query

[prakash2000]

Dear All,

Every week im preparing weekly report based on the following query. last one month its worked properly but this week its not working.

my DB fidld "DateTime" Varchar type.it capture following format date and times "January 31, 2010, 1:50:05 pm"


$sqlQuery="SELECT Center,count(*)as rec FROM res_DB where DateTime BETWEEN '".$st_date."%' and '".$sto_date."%' GROUP BY Center";

details
-------
st_date - starting week date
sto_date - End of the week


pl. help me where is the problem.


thanks in advance.
prakash

 

[r937]

the problem is here --

my DB fidld "DateTime" Varchar type

change this to DATETIME type

(also, pick a better column name than "DateTime")

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[prakash2000]

still not working. any suggestions

 

[r937]

dump the table and a few rows of data so that we can try it ourselves

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[prakash2000]

Hi r937,
Thanks for ur reply, i tryed type changing option locally (varchar into DateTime format)after convert my data and times r lost. its shows 0000-00-00 00:00:00 what can i do pl. help me. so for im having more then 700 rows in different date and time.

 

[r937]

do you have a backup?

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon