List:General Discussion« Previous MessageNext Message »
From:Sebastian Date:August 15 2005 7:51pm
Subject:unix timestamp
View as plain text  
i have this query:

SELECT COUNT(*) AS score FROM downloads WHERE date_add(dateline,
interval 1 hour) >= now() GROUP BY filename ORDER BY score DESC

unfortunately for other reasons i had to change `dateline` to unix timestamp so this query
is no longer able to run as intended. can anyone help with a work around? 

btw, i am using php to run queries if that helps find a solution.






-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.9/72 - Release Date: 8/14/2005

Thread
unix timestampSebastian15 Aug
  • Re: unix timestampSGreen15 Aug
  • Re: unix timestampChris15 Aug
  • Re: unix timestampScott Gifford15 Aug
    • Re: unix timestampKeith Ivey15 Aug
      • Re: unix timestampScott Gifford15 Aug
  • Re: unix timestampBastian Balthazar Bux15 Aug