salix/db/routines/vn2008/views/time.sql

12 lines
294 B
MySQL
Raw Permalink Normal View History

CREATE OR REPLACE DEFINER=`root`@`localhost`
SQL SECURITY DEFINER
VIEW `vn2008`.`time`
AS SELECT `t`.`dated` AS `date`,
`t`.`period` AS `period`,
`t`.`month` AS `month`,
`t`.`year` AS `year`,
`t`.`day` AS `day`,
`t`.`week` AS `week`,
`t`.`yearMonth` AS `yearMonth`
FROM `vn`.`time` `t`