/* Create a table we can experiment with.
 */
CREATE TABLE
   test005 (my_date DATE);

/* Insert December 5, 2000 */
INSERT INTO test005 VALUES('2000-12-05');

/* Insert May 12, 2000 */
INSERT INTO test005 VALUES('2000-05-12');

SELECT * FROM test005
GO

/* Select a verbose date format. */
SELECT
  CONCAT( DAYNAME(my_date),    ", ",
          MONTHNAME(my_date),  " ",
          DAYOFMONTH(my_date), ", ",
          YEAR(my_date) ) AS longdate
FROM test005;

/* Select the Arabic date format. */
SELECT
  CONCAT(RIGHT(YEAR(my_date), 2),
         "/",
         LPAD(MONTH(my_date), 2, "0"),
         "/",
         LPAD(DAYOFMONTH(my_date), 2, "0"))
  AS the_date
FROM test005;