Public feed #722713

Something

public sql v1 · immutable
Raw Edit
·published 2007-10-02 07:52 UTC
rendered paste body
SELECT * FROM (	SELECT 						CASE dayofweek(NOW()) 						WHEN 1 THEN "Dimanche"						WHEN 2 THEN "Lundi"						WHEN 3 THEN "Mardi" 						WHEN 4 THEN "Mercredi" 						WHEN 5 THEN "Jeudi" 						WHEN 6 THEN "Vendredi" 						WHEN 7 THEN "Samedi"  						ELSE "plus" END					AS today,						CASE dayofweek(DATE_ADD(NOW(), INTERVAL 1 DAY)) 						WHEN 1 THEN "Dimanche"						WHEN 2 THEN "Lundi"						WHEN 3 THEN "Mardi" 						WHEN 4 THEN "Mercredi" 						WHEN 5 THEN "Jeudi" 						WHEN 6 THEN "Vendredi" 						WHEN 7 THEN "Samedi"  						ELSE "plus" END					AS tomorrow					FROM (						'2007-05-01' AS date_from					)					as init1				) as init2;