¾ÆÀ̵ð ºñ¹Ð¹øÈ£ | ȸ¿ø°¡ÀÔ | ºñ¹Ð¹øÈ£ºÐ½Ç
   
¡¡»õ·Î¿î¼Ò½Ä
¡¡FAQ
¡¡À¥ÇÁ·Î±×·¥
¡¡À¥DB
¡¡À¥¼­¹ö
¡¡À¥ÇÁ·Î±×·¥¼öÁ¤
¡¡ÇØÇÇÄ®·³
¡¡°ñµåÆÁ
 
Á¦ÀÛÀÇ·Ú
À¥ÇÁ·Î±×·¥ ÆǸŸô
 
ÇöÀçÀ§Ä¡: ¸ÞÀÎ ÇØÇÇÆ÷·³ Ȳ±Ý : °Ô½Ã¹° ÆîÃÄÀбâ
Total related article : 1  
µî·ÏÀÏ:2005-01-15
½Ã°£:11:49:42
Á¶È¸¼ö:5931
from:211.199.35.153
[mysql] ÇöÀçÀúÀåµÈ ½Ã°£¿¡¼­ ÀÏÁ¤½Ã°£À» »©±â ±Û¾´ÀÌ : HappyCGI

ÇØÇÇCGI ÀÔ´Ï´Ù.

°¡²û ¿Ü±¹¼­¹öÀÇ °æ¿ì ½Ã°£ÀÌ ¸ÂÁö ¾Ê´Â °æ¿ì°¡ Á¾Á¾ÀÖÁÒ.

½Ã°£À» ´õÇѴٰųª »©´Â °æ¿ì DB¿¡ ÀúÀåµÈ °ªÀ» º¯°æÇÏÁö ¾Ê°í mysql¿¡¼­ ó¸®ÇÏ´Â ¹æ¹ýÀÔ´Ï´Ù.

bbs_date ¶ó´Â Çʵ忡¼­ ½Ã°£À» 9½Ã°£ »©´Â °æ¿ì
[ÇÁ·Î±×·¥ÄÚµå]
select *,DATE_SUB(  bbs_date,  INTERVAL '0 9' DAY_HOUR  ) as tt


bbs_date ¶ó´Â Çʵ忡¼­ ½Ã°£À» 9½Ã°£ ´õÇÏ´Â °æ¿ì
[ÇÁ·Î±×·¥ÄÚµå]
 select *,DATE_ADD(  bbs_date,  INTERVAL '0 9' DAY_HOUR  ) as tt


ÁÁÀº ÇÏ·çµÇ¼¼¿ä.

 


  

 
¨Ô
Á¦¸ñ
ÀÛ¼ºÀÎ
Á¶È¸
µî·ÏÀÏ
[mysql] ÇöÀçÀúÀåµÈ ½Ã°£¿¡¼­ ÀÏÁ¤½Ã°£À» »©±â
HappyCGI
5931
2005-01-15 11:49:42
 

  HOME | ȸ»ç¼Ò°³ | Á¦ÀÛÀÇ·Ú | °³ÀÎÁ¤º¸Ãë±Þ¹æħ | CGIMALL | ÀÚ·á½Ç | »çÀÌÆ®µî·Ï | ·©Å·100 | Æ÷·³ | Ãʺ¸°¡À̵å | Áú¹®°ú´äº¯ | ¹è³Ê±¤°í
Copyright¨Ï1997~2008 HappyCGI All rights reserved
Powered By HappyCGI