Ricavara data ultimo lunedì o altro giorno della settimana
Tip scritto da g2d
circa un anno fa
Ricavare la data dell'ultimo lunedi martedi ... domenica. Nella query ci sono gli esempi per tutti i giorni della settimana.
1SET @ld := 0; # 0 = lun, 1 = mar, 2 = mer, 3 = gio, 4 = ven, 5 = sab, 6 = dom 2select last_day('2009-12-01') - interval (7 - @ld + weekday(last_day('2009-12-01'))) % 7 day AS `Last Monday` 3 4select last_day('2009-12-01') - interval(7 - 0 + weekday(last_day('2009-12-01'))) % 7 day as ultimo_lunedi 5select last_day('2009-12-01') - interval(7 - 1 + weekday(last_day('2009-12-01'))) % 7 day as ultimo_martedi 6select last_day('2009-12-01') - interval(7 - 2 + weekday(last_day('2009-12-01'))) % 7 day as ultimo_mercoledi 7select last_day('2009-12-01') - interval(7 - 3 + weekday(last_day('2009-12-01'))) % 7 day as ultimo_giovedi 8select last_day('2009-12-01') - interval(7 - 4 + weekday(last_day('2009-12-01'))) % 7 day as ultimo_venerdi 9select last_day('2009-12-01') - interval(7 - 5 + weekday(last_day('2009-12-01'))) % 7 day as ultimo_sabato 10select last_day('2009-12-01') - interval(7 - 6+ weekday(last_day('2009-12-01'))) % 7 day as ultima_domenica
Tip precedente: Convertire campo varchar (gg-mm-aaaa) in datetime
Tip successivo: Record casuali con php
MySQL Report un tool di shell per tenere tutto sotto controllo