I have a job postings board that I'm running in PHP/MySQL and thinking of trying to run it in YQL and Google Docs instead. I have a line of MySQL that fetches job postings that have b开发者_JS百科een posted in the last 60 days only:
$sql = "SELECT * FROM `job` WHERE Curdate( ) <= DATE_ADD( `postdate` , INTERVAL 60 DAY ) ORDER BY `postdate` DESC;";
Is there a YQL equivalent of this? (The format of the timestamp column in the spreadsheet of form submissions in Google Docs is:
2/11/2011 10:23:37
YQL doesn't currently have the option of custom functions within queries, so your Curdate(), DATE_ADD(), etc. are out of the question.  However, there is no reason why you could not craft queries like:
SELECT * FROM job WHERE postdate > $date ORDER BY postdate DESC;
Where $date is an integer timestamp (if that is available in your Google doc?). Or,
SELECT * FROM job WHERE interval = 60; 
This latter query would need a bespoke Data Table to interpret the query parameter(s) and format a query against your Google doc.  An advantage of crafting your own table would be that you are able to use JavaScript (in an <execute> block) to perform server-side processing (like one would in PHP) in YQL.
 
         
                                         
                                         
                                         
                                        ![Interactive visualization of a graph in python [closed]](https://www.devze.com/res/2023/04-10/09/92d32fe8c0d22fb96bd6f6e8b7d1f457.gif) 
                                         
                                         
                                         
                                         加载中,请稍侯......
 加载中,请稍侯......
      
精彩评论