X
  • Search
  • Products
  • Services
  • Resources
  • About
  • Contact
  • Login

Copyright © 2023 MariaDB. All rights reserved.

  • Knowledge Base
  • Contact
  • Login
  • Search
  • Products
  • Services
  • Pricing
  • Resources
  • About Us
  • Download
Knowledge Base » MariaDB Server Documentation » Using MariaDB Server » SQL Statements & Structure » SQL Statements » Built-in Functions » Date & Time Functions » DAY
  • Home
  • Open Questions
  • MariaDB Server
  • MariaDB MaxScale
  • MariaDB ColumnStore
  • Connectors
History Source Flag as Spam / Inappropriate Translate
Created
12 years, 10 months ago
Modified
4 years ago
Type
article
Status
active
License
GPLv2 fill_help_tables.sql
  • History
  • Comments
Edit
Attachments
No attachments exist
Localized Versions
  • DAY [it]

DAY

Syntax

DAY(date)

Description

DAY() is a synonym for DAYOFMONTH().

  • ← DATE_SUB
  • ↑ Date & Time Functions ↑
  • DAYNAME →

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
  • ↑ Date & Time Functions ↑
  • Microseconds in MariaDB
  • Date and Time Units
  • ADD_MONTHS
  • ADDDATE
  • ADDTIME
  • CONVERT_TZ
  • CURDATE
  • CURRENT_DATE
  • CURRENT_TIME
  • CURRENT_TIMESTAMP
  • CURTIME
  • DATE FUNCTION
  • DATEDIFF
  • DATE_ADD
  • DATE_FORMAT
  • DATE_SUB
  • DAY
  • DAYNAME
  • DAYOFMONTH
  • DAYOFWEEK
  • DAYOFYEAR
  • EXTRACT
  • FROM_DAYS
  • FROM_UNIXTIME
  • GET_FORMAT
  • HOUR
  • LAST_DAY
  • LOCALTIME
  • LOCALTIMESTAMP
  • MAKEDATE
  • MAKETIME
  • MICROSECOND
  • MINUTE
  • MONTH
  • MONTHNAME
  • NOW
  • PERIOD_ADD
  • PERIOD_DIFF
  • QUARTER
  • SECOND
  • SEC_TO_TIME
  • STR_TO_DATE
  • SUBDATE
  • SUBTIME
  • SYSDATE
  • TIME Function
  • TIMEDIFF
  • TIMESTAMP FUNCTION
  • TIMESTAMPADD
  • TIMESTAMPDIFF
  • TIME_FORMAT
  • TIME_TO_SEC
  • TO_DAYS
  • TO_SECONDS
  • UNIX_TIMESTAMP
  • UTC_DATE
  • UTC_TIME
  • UTC_TIMESTAMP
  • WEEK
  • WEEKDAY
  • WEEKOFYEAR
  • YEAR
  • YEARWEEK
Products
  • MariaDB Platform
  • MariaDB SkySQL
  • Pricing
  • Download MariaDB
Services
  • Remote DBA
  • SkyDBA
  • Enterprise Architect
  • Technical Support
  • Migration Practice
  • Consulting
  • Training
Resources
  • Documentation
  • Developers
  • Blog
  • Support
  • OpenWorks
  • Customer Stories
  • Events
  • MariaDB Roadshow
About
  • Contact
  • Leadership
  • Partners
  • Newsroom
  • Investors
  • Careers
  • Trust Center
  • Vulnerability Reporting
Contact

Subscribe to our newsletter!

  • Legal
  • Privacy Policy
  • Cookie Policy

Copyright © 2023 MariaDB. All rights reserved.