Website, Ecommerce, Software and Apps Articles

Category: Uncategorized

  • Display MySQL date with short name using query

    To display a MySQL date with a short month name, such as “Jan” for January, we have to use the DATE_FORMAT() function with the %b format specifier.

    Here is an example using SQL Query:

    Code

    SELECT DATE_FORMAT('2025-10-10', '%d-%b-%Y');

    This SQL query will return the date in the format “10-Oct-2025”.

    We can also include other short names, such as the abbreviated weekday name, using the %a specifier:

    SQL Code

    SELECT DATE_FORMAT('2025-10-10', '%a, %d %b %Y');

    This query would return “Fri, 10 Oct 2025”.