![]() Here’s an example of formatting the time component: SELECT DATE_FORMAT(' 11:03:15', '%H:%i:%s %p') ![]() There are many more format specifiers available that enable you to specify a precise format for dates, as well as the time component. ![]() In this example, %W is for the weekday name, %d is for the day of the month, %M is for Month, and %Y is for Year. Here’s an example: SELECT DATE_FORMAT('', '%W, %d %M %Y') In MySQL, the DATE_FORMAT() function allows you to format the date and time.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |