mysql query for different date types

[Latox]

http://www.youtubetomp3.net/statistics

The top stats Videos Converted, that query runs off unix time in db.

The bottom stats Videos Downloaded, runs off normal date like 2009-02-17 18:48:04.

I have 2 queries,

For the Videos Converted-
SELECT DATE(FROM_UNIXTIME(utime)) AS theday, COUNT(id) AS thecount FROM `converted_videos` WHERE `utime`>=UNIX_TIMESTAMP(CURRENT_DATE - INTERVAL 30 DAY) GROUP BY theday ORDER by theday DESC

For the videos downloaded-
SELECT DATE(datetime) AS theday, COUNT(id) AS thecount FROM `downloaded_files` WHERE `datetime`>=UNIX_TIMESTAMP(CURRENT_DATE - INTERVAL 30 DAY) GROUP BY theday ORDER by theday DESC

The videos downloaded is 1 hour infront of the videos converted, so at 11pm the videos downloaded is in new day, whereas videos converted is in previous still.

How would I fix this? What new query will I need for the videos downloaded?

Regards. [mySQL noob]

[r937]

best thing to do would be to fix your code which assigns the times

[Latox]

Its running on a script that has a current of 30,000 rows in the database, inserting over 20,000 values daily...

Can I not do something like -/+ 3600?

[r937]

Can I not do something like -/+ 3600?

yes, but do it while inserting, not while selecting

[Latox]

I need to do it on the already inserted values though.

[r937]

you'll want to use an UPDATE statement, then

[Latox]

If you can update 2009-02-17 18:48:04 as a unixtime, surely you can select it as one.