Date/Time Functions

Date/Time functions are used in working with time and date types (e.g., identifying the day of the week for a given date). Below are the date/time functions supported in the software:

Function Name	Type	Description
Curdate()	Date/Time	Returns the current system date
Day()	Date/Time	Returns a day from an input date
Dayname()	Date/Time	Returns the name of the day of the week from an input date
Dayofweek()	Date/Time	Returns the number of the day of the week from an input date
Hour()	Date/Time	Returns an hour from an input date
Minute()	Date/Time	Returns a minute from an input date
Month()	Date/Time	Returns a month from an input date
Monthname()	Date/Time	Returns the month name from an input date
Second()	Date/Time	Returns a second from an input date
Week()	Date/Time	Returns a week from an input date
Year()	Date/Time	Returns a year from an input date