Do you have a question? Post it now! No Registration Necessary. Now with pictures!
October 19, 2006, 12:34 pm
rate this thread
It is able to extract dowloaders from a table and group them by date.
select count(*) AS downloaders, date_format(date,'%Y-%m-%d') AS
Datesmall, date_format(date,'%D %M %Y') AS Date from downloaders Group
By date_format(date,'%D %M %Y ') order by unix_timestamp(date)")
After moving to 5.0 the query does not work.
I dont have a qyery error but just the query retrieve always zero
After i series of tests i noticed that what is not working is
where unix_timestamp(date) between unix_timestamp('" & From_YY & "-" &
From_MM & "-" & From_DD & "') and unix_timestamp('" & To_YY & "-" &
To_MM & "-" & To_DD & "23:59:59')
which i use to get only downloaders from a range of date.
But i dont know what changed from 3.0 to 5.0 in order to make the query
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum