DB QnA

18133 JAVACHO
2012-05-25 15:45:30
³¯Â¥ Àϼö °è»ê Áú¹®µå¸³´Ï´Ù.

REG_DATE ¶ó´Â Ä®·³¿¡ 20120523 À̶ó´Â VAECHARŸÀÔÀÇ
ÇüÅ·Π³¯Â¥°¡ ÀÔ·ÂÀÌ µÇ¾îÀÖ½À´Ï´Ù

REG_DATE ´Â ¹°°ÇÀ» µî·ÏÇѳ¯Â¥ÀÔ´Ï´Ù.
Àú´Â ¿©±â¼­ ÇØ´ç ¹°°ÇÀÇ µî·ÏÇÑ ³¯Â¥·ÎºÎÅÍÀÇ
»ç¿ëÀÏÀ» ±¸ÇÏ°í ½ÍÀºµ¥¿ä


¿À´Ã³¯Â¥ - REG_DATE = »ç¿ëÀÏ (2 °¡³ª¿À°ÙÁö¿ä)

Àú »ç¿ëÀÏÀ» ±¸ÇÏ°í ½ÍÀºµ¥ ¾î¶²¹æ½ÄÀ¸·Î
Äõ¸®¸¦ ÀÛ¼ºÇؾßÇÒÁö Àß ¸ð¸£°Ú¾î¿ä
µµ¿òÁ» ºÎʵ叮°íÀÚ ±ÛÀ» ³²°å½À´Ï´Ù.

¾î¶»°Ô ÇØ¾ßÇÒÁö Á¶¾ðÁ» ºÎʵ右´Ï´Ù ¤Ð

  • select TO_char(sysdate,'yyyymmdd') - '20120521' from dual
  • 16086MaYa
  • 2012-05-25 15:51:47
  • x
  • ¾Æ DB´Â MYSQL ÀÔ´Ï´Ù
  • 18133
  • 2012-05-25 15:54:04
  • x
  • mysql¿¡´Â datediffÇÔ¼ö°¡ Àִ°Š°°³×¿ä.
  • 6638ÆøÇ³ÄÚµù
  • 2012-05-25 16:07:46
  • x
  • SELECT DATEDIFF(now(), '20120521');

    '20120521'Àº ¼­ºêÄõ¸®·Î ±¸ÇØ¿À½Ã¸é µÉ µí.



    ±×¸®°í, ¿©±â¿¡ ¹°¾îº¸½Ã±â Àü¿¡ ±¸±Û °Ë»öÇÏ½Ã¸é ´õ ¸¹Àº ÀÚ·á°¡ ³ª¿À´Ï Âü°íÇϼ¼¿ä~
  • 17581lostbook
  • 2012-05-25 16:08:46
  • x
  • ¤¾¤¾ ³×
    dateDIFF(date_format(NOW( ), '%Y-%m-%d'), DATE(B.USER_REGDT) ) AS USE_DATE
    ½ÄÀ¸·Î ÇØ°áÇÏ¿´³×¿ä °¨»çÇÕ´Ï´Ù
  • 18133ado18
  • 2012-05-25 16:34:06
  • x
´ÙÀ½±Û ÀÚ¹Ù Double -> DB NUMBER
>> 3999 ³¯Â¥ Àϼö °è»ê Áú¹®µå¸³´Ï´Ù.  [5] JAVACHO 1156 2012-05-25 15:45:30
ÀÌÀü±Û DB¿¡ NUMBER¿¡ °ªÀ» ³ÖÀ¸·Á¸é..