NOW() Devuelve la fecha y la hora actual
CURTIME() Devuelve la hora actual
ADDDATE Suma un número de días a una fecha y calcula la nueva fecha
DATE_FORMAT Nos permite formatear fechas
DATEDIFF Calcula el número de días que hay entre dos fechas
YEAR Devuelve el año de una fecha
MONTH Devuelve el mes de una fecha
MONTHNAME Devuelve el nombre del mes de una fecha
DAY Devuelve el día de una fecha
DAYNAME Devuelve el nombre del día de una fecha
HOUR Devuelve las horas de un valor de tipo DATETIME
MINUTE Devuelve los minutos de un valor de tipo DATETIME
SECOND Devuelve los segundos de un valor de tipo DATETIME
SET GLOBAL lc_time_names := 'es_ES';
SET lc_time_names := 'es_ES';
SELECT
@@GLOBAL.lc_time_names,
@@SESSION.lc_time_names;
SELECT curtime()
UNION all
SELECT CONCAT_WS(":",HOUR(NOW()),minute(NOW()),second(NOW()))
UNION ALL
SELECT HOUR(NOW())
UNION ALL
SELECT dayname(NOW())
UNION ALL
SELECT day(NOW())
UNION ALL
SELECT monthname(NOW())
UNION ALL
SELECT month(NOW())
UNION ALL
SELECT YEAR(adddate(NOW(),-80))
UNION ALL
SELECT DATEDIFF("2025/12/25",NOW())
UNION all
SELECT NOW()
UNION all
SELECT CURTIME()
UNION all
SELECT adddate(NOW(),7)
UNION ALL
SELECT adddate(NOW(),-80);
Format Description
%a Abbreviated weekday name (Sun to Sat)
%b Abbreviated month name (Jan to Dec)
%c Numeric month name (0 to 12)
%D Day of the month as a numeric value, followed by suffix (1st, 2nd, 3rd, …)
%d Day of the month as a numeric value (01 to 31)
%e Day of the month as a numeric value (0 to 31)
%f Microseconds (000000 to 999999)
%H Hour (00 to 23)
%h Hour (00 to 12)
%I Hour (00 to 12)
%i Minutes (00 to 59)
%j Day of the year (001 to 366)
%k Hour (0 to 23)
%l Hour (1 to 12)
%M Month name in full (January to December)
%m Month name as a numeric value (00 to 12)
%p AM or PM
%r Time in 12 hour AM or PM format (hh:mm:ss AM/PM)
%S Seconds (00 to 59)
%s Seconds (00 to 59)
%T Time in 24 hour format (hh:mm:ss)
%U Week where Sunday is the first day of the week (00 to 53)
%u Week where Monday is the first day of the week (00 to 53)
%V Week where Sunday is the first day of the week (01 to 53). Used with %X
%v Week where Monday is the first day of the week (01 to 53). Used with %x
%W Weekday name in full (Sunday to Saturday)
%w Day of the week where Sunday=0 and Saturday=6
%X Year for the week where Sunday is the first day of the week. Used with %V
%x Year for the week where Monday is the first day of the week. Used with %v
%Y Year as a numeric, 4-digit value
%y Year as a numeric, 2-digit value