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
Post a Comment