Database Date-time functions

Surdate (), Current_date ()

Returns the current date

Curtime (), Current_time

Return Current time

Now (), Current_timestamp (), localtime (), Sysdate (), Localtimestamp ()

Returns the current date and time

Year (d),

Returns the year value in Date D

Month (d)

Returns the month value in Date D

Day (d)

Returns the date value in Date D

MonthName (d)

Returns the month name in the date,

Dayname (d)

Return Date D is the day of the week

DayOfWeek (d)

Date d today is the day of the week, 1 is Monday, 2 is Tuesday

Weekday (d)

Date d days is the day of the week, 0 is Monday, 2 is Tuesday

Week (d), WeekOfYear (d)

Calculated Date d is the week ordinal of the year, the range is 0->53

DayOfYear (d)

Calculated Date D is the day ordinal of this year

DayOfMonth (d)

Calculated Date D is the day of the month

Quarter (d)

Return Date D is the first season, return 1->4

Hour (t)

Return the time value on the way

Minute (t)

Returns the minute value in T

Second (t)

Returns the seconds value in T

Database Date-time functions