DATE_FORMAT()
|
|
Reference:
|
|
MariaDB [mytest]> select cidx, CTIME, DATE_FORMAT(CTIME,'%W %M %Y') from datatypetestm order by cidx;
|
-------------------------------------------
|
|
cidx CTIME DATE_FORMAT(CTIME,'%W %M %Y')
|
-------------------------------------------
|
|
1 13:00:00 NULL
|
-------------------------------------------
|
1 row in set (0.000 sec)
|
|
MariaDB [mytest]> select cidx, CTIME, DATE_FORMAT(CTIME,'%D %y %a %d %m %b %j') from datatypetestm order by cidx;
|
-------------------------------------------------------
|
|
cidx CTIME DATE_FORMAT(CTIME,'%D %y %a %d %m %b %j')
|
-------------------------------------------------------
|
|
1 13:00:00 NULL
|
-------------------------------------------------------
|
1 row in set (0.000 sec)
|
|
ColumnStore:
|
|
MariaDB [mytest]> select cidx, CTIME, DATE_FORMAT(CTIME,'%W %M %Y') from datatypetestm order by cidx;
|
-------------------------------------------
|
|
cidx CTIME DATE_FORMAT(CTIME,'%W %M %Y')
|
-------------------------------------------
|
|
1 13:00:00 Monday October 2018
|
-------------------------------------------
|
1 row in set (0.031 sec)
|
|
MariaDB [mytest]> select cidx, CTIME, DATE_FORMAT(CTIME,'%D %y %a %d %m %b %j') from datatypetestm order by cidx;
|
-------------------------------------------------------
|
|
cidx CTIME DATE_FORMAT(CTIME,'%D %y %a %d %m %b %j')
|
-------------------------------------------------------
|
|
1 13:00:00 1st 18 Mon 01 10 Oct 274
|
-------------------------------------------------------
|
1 row in set (0.007 sec)
|