dz¼±µµ¿ò¸»... |
|
ÄÄÇ»ÅÍ¿Í °ü·ÃÀÖ´Â ¸ðµç ÆÁÀ» °øÀ¯ÇսôÙ.
mysql> SELECT DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
-> 'Saturday October 1997' mysql> SELECT DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s'); -> '22:23:00' mysql> SELECT DATE_FORMAT('1997-10-04 22:23:00', '%D %y %a %d %m %b %j'); -> '4th 97 Sat 04 10 Oct 277' mysql> SELECT DATE_FORMAT('1997-10-04 22:23:00', '%H %k %I %r %T %S %w'); -> '22 22 10 10:23:00 PM 22:23:00 00 6' mysql> SELECT DATE_FORMAT('1999-01-01', '%X %V'); -> '1998 52' mysql> SELECT DATE_FORMAT('2006-06-00', '%d'); -> '00' TAG : db
|
ºÎ»ê±¤¿ª½Ã ºÎ»êÁø±¸ ´ç°¨ 4µ¿ 659-1. ÁÁÀº ¼ÒÇÁÆ®¿þ¾î °³¹ß ¿îµ¿º»ºÎ. ´ëÇ¥ ¾ÈµæÈ£ / sinmungo @ hotmail . com Copyright(c) È£°¡°èºÎ. All Rights Reserved. Since 2003. 04 |