USE SPRINGFIELD; SELECT CURDATE() FECHA; SELECT CURRENT_DATE() FECHA; SELECT CURTIME() HORA; SELECT CURRENT_TIME() HORA; SELECT CURRENT_TIMESTAMP(), LOCALTIME(), LOCALTIMESTAMP(), NOW(); SELECT SYSDATE(); SELECT DATE('1989-12-17'); SELECT DATE('1989-12-17 20:30:15'); SELECT DATE('1989-12-17 20:30:15.000001'); SELECT DATE('La fecha de la primera emision fue 1989-12-17'); SELECT DATE(NULL); SELECT DATE_FORMAT('1989-12-17 20:30:15.000001','%Y'); SELECT DATE_FORMAT('1989-12-17 20:30:15.000001','%y'); SELECT DATE_FORMAT('1989-12-17 20:30:15.000001','%M'); SELECT DATE_FORMAT('1989-12-17 20:30:15.000001','%m'); SELECT DATE_FORMAT('1989-12-17 20:30:15.000001','%D'); SELECT DATE_FORMAT('1989-12-17 20:30:15.000001','%d'); SELECT DATE_FORMAT('1989-12-17 20:30:15.000001','%d/%m/%Y'); SELECT DATE_FORMAT('1989-12-17 20:30:15.000001','%D %M ,%Y'); SELECT DATE_FORMAT('1989-12-17 20:30:15.000001','%W'); SELECT DATE_FORMAT('1989-12-17 20:30:15.000001','%w'); SELECT TIME_FORMAT('1989-12-17 20:30:15.000001','%f'); SELECT TIME_FORMAT('1989-12-17 20:30:15.000001','%H'), TIME_FORMAT('1989-12-17 20:30:15.000001','%h'), TIME_FORMAT('1989-12-17 20:30:15.000001','%r'); SELECT TIME_FORMAT('1989-12-17 20:30:15.000001','%i'); SELECT TIME_FORMAT('1989-12-17 20:30:15.000001','%T'); SELECT SECOND('1989-12-17 20:30:15.000001'); SELECT MINUTE('1989-12-17 20:30:15.000001'); SELECT HOUR('1989-12-17 20:30:15.000001'); SELECT DAY('1989-12-17 20:30:15.000001'); SELECT DAY('1989-12-17 20:30:15.000001'), DAYOFMONTH('1989-12-17 20:30:15.000001'), DAYNAME('1989-12-17 20:30:15.000001'); SELECT DAYOFWEEK('1989-12-17 20:30:15.000001'), DAYOFYEAR('1989-12-17'); SELECT LAST_DAY('1989-12-17 20:30:15.000001'); SELECT DAY('1989-12-17 20:30:15.000001'); SELECT WEEK('1989-12-17 20:30:15.000001'); SELECT WEEKDAY('1989-12-17 20:30:15.000001'), WEEKOFYEAR('1989-12-17 20:30:15.000001'), YEARWEEK('1989-12-17 20:30:15.000001', 5); SELECT MONTH('1989-12-17 20:30:15.000001'), MONTHNAME('1989-12-17 20:30:15.000001'); SELECT QUARTER('1989-12-17 20:30:15.000001'); SELECT YEAR('1989-12-17 20:30:15.000001'); SELECT EXTRACT(MICROSECOND FROM '1989-12-17 20:30:15.000001'); SELECT EXTRACT(SECOND FROM '1989-12-17 20:30:15.000001'); SELECT EXTRACT(MINUTE FROM '1989-12-17 20:30:15.000001'); SELECT EXTRACT(HOUR FROM '1989-12-17 20:30:15.000001'); SELECT EXTRACT(DAY FROM '1989-12-17 20:30:15.000001'); SELECT EXTRACT(WEEK FROM '1989-12-17 20:30:15.000001'); SELECT EXTRACT(MONTH FROM '1989-12-17 20:30:15.000001'); SELECT EXTRACT(QUARTER FROM '1989-12-17 20:30:15.000001'); SELECT EXTRACT(YEAR FROM '1989-12-17 20:30:15.000001'); SELECT '1989-12-17 20:30:15.000001' FECHA, ADDDATE('1989-12-17 20:30:15.000001', INTERVAL 4 MICROSECOND) FECHA2; SELECT '1989-12-17 20:30:15.000001' FECHA, ADDDATE('1989-12-17 20:30:15.000001', INTERVAL 4 SECOND) FECHA2; SELECT '1989-12-17 20:30:15.000001' FECHA, ADDDATE('1989-12-17 20:30:15.000001', INTERVAL 4 MINUTE) FECHA2; SELECT '1989-12-17 20:30:15.000001' FECHA, ADDDATE('1989-12-17 20:30:15.000001', INTERVAL 4 HOUR) FECHA2; SELECT '1989-12-17 20:30:15.000001' FECHA, ADDDATE('1989-12-17 20:30:15.000001', INTERVAL 4 DAY) FECHA2, ADDDATE('1989-12-17 20:30:15.000001',4) FECHA3; SELECT '1989-12-17 20:30:15.000001' FECHA, ADDDATE('1989-12-17 20:30:15.000001', INTERVAL 4 WEEK) FECHA2; SELECT '1989-12-17 20:30:15.000001' FECHA, ADDDATE('1989-12-17 20:30:15.000001', INTERVAL 4 MONTH) FECHA2; SELECT '1989-12-17 20:30:15.000001' FECHA, ADDDATE('1989-12-17 20:30:15.000001', INTERVAL 4 YEAR) FECHA2; SELECT '1989-12-17 20:30:15.000001' FECHA, SUBDATE('1989-12-17 20:30:15.000001', INTERVAL 4 MICROSECOND) FECHA2; SELECT '1989-12-17 20:30:15.000001' FECHA, SUBDATE('1989-12-17 20:30:15.000001', INTERVAL 4 SECOND) FECHA2; SELECT '1989-12-17 20:30:15.000001' FECHA, SUBDATE('1989-12-17 20:30:15.000001', INTERVAL 4 MINUTE) FECHA2; SELECT '1989-12-17 20:30:15.000001' FECHA, SUBDATE('1989-12-17 20:30:15.000001', INTERVAL 4 HOUR) FECHA2; SELECT '1989-12-17 20:30:15.000001' FECHA, SUBDATE('1989-12-17 20:30:15.000001', INTERVAL 4 DAY) FECHA2, SUBDATE('1989-12-17 20:30:15.000001',4) FECHA3; SELECT '1989-12-17 20:30:15.000001' FECHA, SUBDATE('1989-12-17 20:30:15.000001', INTERVAL 4 WEEK) FECHA2; SELECT '1989-12-17 20:30:15.000001' FECHA, SUBDATE('1989-12-17 20:30:15.000001', INTERVAL 4 MONTH) FECHA2; SELECT '1989-12-17 20:30:15.000001' FECHA, SUBDATE('1989-12-17 20:30:15.000001', INTERVAL 4 YEAR) FECHA2; SELECT '1989-12-17 20:30:15.000001' FECHA, SUBDATE('1989-12-17 20:30:15.000001', INTERVAL 4 SECOND_MICROSECOND) FECHA2; SELECT '1989-12-17 20:30:15.000001' FECHA, ADDTIME('1989-12-17 20:30:15.000001','0.000001') FECHA2; SELECT '1989-12-17 20:30:15.000001' FECHA, ADDTIME('1989-12-17 20:30:15.000001','2.000001') FECHA2; SELECT '1989-12-17 20:30:15.000001' FECHA, ADDTIME('1989-12-17 20:30:15.000001','3:2.000001') FECHA2; SELECT '1989-12-17 20:30:15.000001' FECHA, ADDTIME('1989-12-17 20:30:15.000001','3:4:2.000001') FECHA2; SELECT '1989-12-17 20:30:15.000001' FECHA, ADDTIME('1989-12-17 20:30:15.000001','3:4:5:2.000001') FECHA2; SELECT '1989-12-17 20:30:15.000001' FECHA, SUBTIME('1989-12-17 20:30:15.000001','0.000001') FECHA2; SELECT '1989-12-17 20:30:15.000001' FECHA, SUBTIME('1989-12-17 20:30:15.000001','2.000001') FECHA2; SELECT '1989-12-17 20:30:15.000001' FECHA, SUBTIME('1989-12-17 20:30:15.000001','3:2.000001') FECHA2; SELECT '1989-12-17 20:30:15.000001' FECHA, SUBTIME('1989-12-17 20:30:15.000001','3:4:2.000001') FECHA2; SELECT '1989-12-17 20:30:15.000001' FECHA, SUBTIME('1989-12-17 20:30:15.000001','3:4:5:2.000001') FECHA2; SELECT PERIOD_ADD(198912,6); SELECT MAKEDATE(1989, 351), MAKETIME(20,30,15); SELECT DATEDIFF('1989-12-17 20:30:15.000001','1994-12-01 14:00:00.000001'), DATEDIFF('1994-12-01 14:00:00.000001', '1989-12-17 20:30:15.000001'); SELECT TIMEDIFF('1989-12-17 20:30:15.000001','1994-12-01 14:00:00.000001'), TIMEDIFF('1994-12-01 14:00:00.000001', '1989-12-17 20:30:15.000001') , TIMEDIFF('1989-12-17 20:30:15.000001','1989-12-01 14:00:00.000001'), TIMEDIFF('1989-12-01 14:00:00.000001', '1989-12-17 20:30:15.000001') ; SELECT PERIOD_DIFF(198912,199412), PERIOD_DIFF(199412,198912); SELECT TO_DAYS('1989-12-17 20:30:15.000001'); SELECT FROM_DAYS(726818); SELECT STR_TO_DATE ('17/12/1989','%d/%m/%Y'); SELECT SEC_TO_TIME(1), TIME_TO_SEC('00:00:01') , SEC_TO_TIME(7001), TIME_TO_SEC('01:56:41') , SEC_TO_TIME(-70), TIME_TO_SEC('-00:01:18');