MySQL time function

xiaoxiao2021-04-01  196

MySQL time function:

1 TO_DAYS () Convert to the number of days; dayofweek (), weekday (Date), get the week: dayofweek (), dayofmonth, dayofyea, week, month, year, date,

2 Time Addressing: Date_Sub (now (), Interval 10 Type): Date_Add (), Adddate, Subdate Type: Sencod, Minute, Hour, Secnotod, Day, Month, Year,

Minute_second "Minutes: Seconds" Hour_Minute "Hours: minutes" day_HOUR "Days Hours" Year_Mont "Years-Months" Hour_second "Hours: minutes: seconds" day_minute "days hours: minutes" day_second

3: Time format: DATE_FORMAT:

Mono - Month Name (January..December)% W Week's name (0th, 1st, 2nd, 3rd, etc.)% (0th, 1st, 2nd, 3rd, ETC.)% In English suffix Y years, digital, 4-bit% Y year, number, 2-bit% x weekly value year, Sunday is the first day, digital, 4 digits, use% X Week with '% V' The year, Monday is a week on the first day, the number, 4 digits, with '% V' uses the number of days (Sun..st)% D, number of days, numbers in the month (00] (00. .31)% of the number of days in the month, the number (0..31)% M month, the number (00..12)%, the number of (0..12)% B abbreviation (JAN .. DEC)% J A number of days (001..366)% h hour (00..23)% k h hour (01..12)% i h hours (01..12)% i h hours (01..12)% I h. .12)% l hours (1..12)% i minute, digital (聽 00..59)% R Time, 12 hours (HH: mm: SS [AP] M)% T Time, 24 hours (HH: MM: SS)% s second (00..59)% s second (00..59)% p AM or PM% W One number in one week (0 = sunday..6 = SATURDAY)% u Week (00 .. 53), Sunday is a week's first day% u Week (00..53), Monday is a week's first day% V Week (01..53), Sunday is a week on the first day. Using% V weeks (01..53) together with '% x', Monday is the first day of a week. Using %% with '% x'

转载请注明原文地址:https://www.9cbs.com/read-131108.html

New Post(0)