±Û¾´ÀÌ :±èÇÊÈ£ 1998³â 8¿ù 22ÀÏ 18:38:46
In Reply to: [Áú¹®] sybaseÀÇ datetime »ç¿ëÇϱâ posted by °½Åµ¿ on 1998³â 8¿ù 21ÀÏ 17:13:49:
SyBase DB ´Â ´Ù·ç¾î º¸Áö ¾Ê¾ÒÁö¸¸
ÃßÃøÀ¸·Î¸¸ ´äº¯ µå¸³´Ï´Ù.
(ÀÌ ´äº¯ÀÌ Æ²¸± ¼öµµ ÀÖ½À´Ï´Ù.)
MS SQL µµ ±× »Ñ¸®´Â SyBase À̴ϱî
³¯Â¥ ºÎºÐ ´Ù·ç´Â ¹æ½ÄÀº ¾Æ¸¶µµ ºñ½ÁÇϸ®¶ó°í º¾´Ï´Ù.
insert into test values('1998/08/21 21:05:30:110')
À¸·Î ÇÏ¸é ¹Ð¸®ÃÊ ±îÁö µé¾î °¥ °Ì´Ï´Ù.
ÇöÀç ½Ã°¢À» ÀúÀåÇÒ·Á¸é
insert into test values(GetDate())
ÇÏ¸é µÇ°í,
³¯Â¥ °ü·Ã º¯È¯Àº Convert() ÇÔ¼ö¸¦ »ç¿ëÇÕ´Ï´Ù.
±×·³...