yahoo - YQL equivalent of MySQL's 'INTERVAL'? -


i have job postings board i'm running in php/mysql , thinking of trying run in yql , google docs instead. have line of mysql fetches job postings have been posted in last 60 days only:

$sql = "select * `job` curdate( ) <= date_add( `postdate` , interval 60 day ) order `postdate` desc;"; 

is there yql equivalent of this? (the format of timestamp column in spreadsheet of form submissions in google docs is:

2/11/2011 10:23:37 

yql doesn't have option of custom functions within queries, curdate(), date_add(), etc. out of question. however, there no reason why not craft queries like:

select * job postdate > $date order postdate desc; 

where $date integer timestamp (if available in google doc?). or,

select * job interval = 60;  

this latter query need bespoke data table interpret query parameter(s) , format query against google doc. advantage of crafting own table able use javascript (in <execute> block) perform server-side processing (like 1 in php) in yql.


Comments

Popular posts from this blog

apache - Add omitted ? to URLs -

redirect - bbPress Forum - rewrite to wwww.mysite prohibits login -

php - How can I stop spam on my custom forum/blog? -