Public feed #722445

Something

public sql v1 · immutable
Raw Edit
·published 2007-10-02 00:26 UTC
rendered paste body
 SELECT IF( DAYOFWEEK( date_from ) >=2AND DAYOFWEEK( date_from ) <=6, IF( DATEDIFF( date_to, date_from ) , 2, 1 ) , 1 ) AS nFROM (SELECT '2007-05-02' AS date_from, '2007-12-02' AS date_to) AS init