1 2 3 4 5 6 7 8 9 10
| CREATE VIEW vplan_creneau AS
SELECT crn_id as vcrn_creneau,
crn_date as vcrn_date,
crn_default as vcrn_default,
dix_debut as vcrn_debut,
dix_fin as vcrn_fin,
STR_TO_DATE(concat(DATE_FORMAT(crn_date,GET_FORMAT(DATE, 'ISO')),' ',dix_debut),concat(GET_FORMAT(DATE, 'ISO'),' %H:%i')) as vcrn_date_debut,
STR_TO_DATE(concat(DATE_FORMAT(crn_date,GET_FORMAT(DATE, 'ISO')),' ',dix_fin),concat(GET_FORMAT(DATE, 'ISO'),' %H:%i')) as vcrn_date_fin
FROM plan_dixieme,plan_creneau
WHERE dix_id = crn_dixieme; |
Partager