

- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What are the different time format characters used by MySQL DATE_FORMAT() function?
Different time format characters used by MySQL DATE_FORMAT() function are as follows −
Time Format Character | Meaning |
---|---|
%H | It is used to abbreviate Hour on a 24-hour clock in two digits format like 00, 01, 02 up to 23. |
%h | It is used to abbreviate Hour on 12-hour clock in two digits format like 01, 02 up to 12. |
%i | It is used to abbreviate minutes in two digits format like 01, 02 up to 59. |
%l | It is used to abbreviate Hour on 12-hour clock in two digits format without zero-like 01, 02 up to 12. |
%p | It is used for A.M or P.M. |
%r | It is used to display time on 12-hour clock as HH:MM:SS. |
%s | It is used to abbreviate seconds in two digits format like 01, 02 up to 59. |
%T | It is used to display time on the 24-hour clock as HH:MM:SS. |
%f | It is used to display Microseconds in the range of 000000..999999. |
- Related Questions & Answers
- What are different date format characters used by MySQL DATE_FORMAT() function?
- How to use together the date and time format characters in MySQL DATE_FORMAT() function?
- What are different format specifiers used in C language?
- MySQL ORDER BY Date field not in date format?
- Format Date and Time in Perl
- Convert MySQL Unix-Timestamp format to date format?
- Convert VARCHAR Date to a different format in MySQL?
- How to convert Python date format to 10-digit date format for mysql?
- MySQL extract year from date format?
- Replace date format with MySQL STR_TO_DATE
- How to change date time format in HTML5?
- Java Program to format date time with Join
- How to format date and time in android?
- How to update the date format in MySQL?
- Change the curdate() (current date) format in MySQL
Advertisements