|
|
|
|
ÇÁ¸®¸Ç / 2001-10-25 / ¿ÀÀü 9:52:49 / 211.241.34.197
Á¶È¸¼ö : 128
|
[Áú¹®] ¾È³çÇϼ¼¿ä.¤Ó ³¯Â¥ ¶¡½Ã·Õ. ^^:; |
> > ¾È³çÇϼ¼¿ä.
> >
> > À̹øÁÖ¿Í. ´ÙÀ½ÁÖ.. ¸¦ ±¸Çߴµ¥..
> >
> > ȸ¿ø¿¡¼ À̹øÁÖ »ýÀÏ ¸®½ºÆ®¿Í ´ÙÀ½ÁÖ ¸®½ºÆ®¸¦ »ÌÀ»·Á°í Çϴµ¥.. Àß ¾ÈµÇ³×¿ë.
> >
> >
> > mydate=weekday(date())
> > mysun=mydate-(mydate-1)
> >
> > mysun1=dateadd("d",-(mydate-1),date)
> > myweek=mysun1+6
> >
> > mynextsun=myweek+1
> > mynextweek=mynextsun+6
> >
> > ´ëÃæÀÌ ÀÌ·¸°Ô Çϴϱñ À̹øÁÖ¿Í ´ÙÀ½ÁÖ¸¦ ¾òÀ»¼ö ÀÖ¾ú´Âµ¥¿ä.
> >
> > ȸ¿øµðºñ¿¡´Â ³â,¿ù,Àϸ¦ µû·Î ÀúÀåÀ» Çߴµ¥..
> >
> > ¾î¶»°Ô °Ë»öÀ» ÇØ¾ß Çϳª¿ä..
> >
> > Á¦°¡ »ý°¢Çß´ø°ÍÀ» Çß´õ´Ï.. ÇÏÇÏ..
> >
> > ¸¸¾à 10¿ù´Þ¿¡ À̹øÁÖ À̸é.
> >
> > ´ÙÀ½ÁÖ°¡ 11¿ù´ÞÀÌ¸é ¹®Á¦°¡ µÇ´õ¶ó±¸¿ä.. ¤Ð.¤Ð;;
> >
> > ±×·¡¼. ÀÌ·¸°Ô ±ÛÀ» ¿Ã¸®°í ÀÖ½À´Ï´Ù.
> >
> > ±×·³.. À̸¸..
> >
> > ºü¸¥.. ´äº¯À» ºÎŹµå¸³´Ï´Ù.
> >
> >
> -----------------------------------------------------------
>
> ÇÑÁÖ´Â ÀÏ¿äÀÏ¿¡ ½ÃÀÛÇؼ Åä¿äÀÏ¿¡ ³¡³ª´Â°Ç ¾Æ½ÇÅ×°í....
>
> À̹øÁÖ ÀÏ¿äÀÏÀÇ ¿ù°ú ÀÏÀ» ±¸ÇÑ´Ù
>
> ´ÙÀ½ÁÖ Åä¿äÀÏÀÇ ¿ù°ú ÀÏÀ» ±¸ÇÑ´Ù.
>
> select »ýÀÏÀλç¶÷
>
> from »ýÀϸñ·Ï
>
> where (¿ù = À̹øÁÖÀÏ¿äÀÏ¿ù AND ÀÏ>= À̹øÁÖÀÏ¿äÀÏÀÏ) OR (¿ù = ´ÙÀ½ÁÖÅä¿äÀÏ¿ù AND ÀÏ<= ´ÙÀ½ÁÖÅä¿äÀÏÀÏ)
>
> ÀÌ·¸°Ô ÇÏ¸é µÉ°Í °°Àºµ¥¿ä...
>
>
-----------------------------------------------------------
À̹øÁÖ ºÎÅÍ ´ÙÀ½ÁÖ ±îÁö °°ÀÌ °¡Á® ¿À´Â°ÍÀÌ ¾Æ´Ñ°¡¿ä??
À̹øÁÖ µû·Î
´ÙÀ½ÁÖ µû·Î °¡Á®¿À°í ½ÍÀºµ¥
|
|
|
|