SELECT WEEK(my_date_field,5) -
WEEK(DATE_SUB(my_date_field, INTERVAL DAYOFMONTH(my_date_field)-1 DAY),5)+1
Posts Tagged ‘SQL’
Home »
Tags » SQL
26Apr
2009
2009
Week of the Month in Mysql
22Apr
2009
2009
Zend_Db_Select multiple table joins explained
It sounds like a simple task - retrieve the result from a join SQL query. Unusually you can even find documentation on the official Zend Framework site explaining how to put together a query that will return the results from a JOIN query. Unfortunately when it actually comes to putting theory into practice any Zend newcomer can run into several problems. (more…)
