¾È³çÇϼ¼¿ä °»ç´Ô
¸ÅºÐ ¾÷µ¥ÀÌÆ®°¡ µÇ´Â µ¥ÀÌÅÍÀÇ Å×ÀÌºí¿¡¼ ÇöÀçÀϸ¸À» ¼±ÅÃÇÏ·Á¸é ¾î¶»°Ô ÇØ¾ß ÇÏ´ÂÁö ±Ã±ÝÇÕ´Ï´Ù.
Å×ÀÌºí¿¡´Â ³¯Â¥ Çü½ÄÀÌ ¾Æ·¡¿Í °°½À´Ï´Ù.
PostDate
2017-07-10 02:20:28.580
2017-07-10 02:21:29.390
2017-07-10 02:22:30.003
2017-07-10 02:23:30.850
2017-07-10 02:24:31.553
2017-07-10 02:25:35.483
2017-07-10 02:26:36.850
2017-07-10 02:27:37.633
2017-07-10 02:28:38.897
2017-07-10 02:29:39.687
2017-07-10 02:30:40.460
ÇØ´ç Volume°ªÀº ¸Å ºÐ¸¶´Ù GetDate() ·Î Å×ÀÌºí¿¡ ÀúÀåÀÌ µÇ´Âµ¥¿ä
Select±¸¹®À» ÀÌ¿ëÇÏ¿© 7¿ù10Àϸ¸ Á¶È¸Çغ¸·Á)°í ÇÕ´Ï´Ù.
Select * from TabeA Where PostDate =Convert(VarChar(10),GetDate(),120)
¶Ç´Â
Select * from TableA Where PostDate =convert(date,getdate())
Select * from TableA Where StockDate = DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))
·Î ÇغÁµµ ÇöÀç ³¯Â¥ÀÇ µ¥ÀÌÅÍ°¡ Ãâ·ÂÀÌ µÇ¾î¾ß Çϴµ¥
Äõ¸®´Â ½ÇÇàÀÌ µÇÁö¸¸ 0°³ÀÇ Çุ ¹ÝȯÀÌ µË´Ï´Ù.
¿Ö ±×·±Áö ÀÌÀ¯¸¦ ¾Ë°í½Í½À´Ï´Ù.
|