·¢Ð»°Ìâ
´òÓ¡

php+mssqlµÄʱ¼ä²»Ò»ÖÂÎÊÌ⣬ºÃÏñºÍµØÇøÉèÖÃÓйأ¬µ«ÊÇÎÒ²»¶®£¡Ð»Ð»ÁË£¡£¡

php+mssqlµÄʱ¼ä²»Ò»ÖÂÎÊÌ⣬ºÃÏñºÍµØÇøÉèÖÃÓйأ¬µ«ÊÇÎÒ²»¶®£¡Ð»Ð»ÁË£¡£¡

php´ÓmssqlÊý¾Ý¿âÖÐÈ¡µÃ×ֶΣ¨ÀàÐÍΪdatetime£©¿âÖÐΪ2003-07-02 11:23:17£¬µ«ÊÇÔÚÒ³ÃæÉÏÏÔʾΪ2003 ÆßÔ 2 11:23:17
¶ø²»ÊÇ2003-07-02 11:23:17 £¬ÎÒÎÞ·¨Í¨¹ýÕâ¸öÊý×鼯Ëãʱ¼ä²î(ÓÃʱ¼ä´ÁÇó²îÖµ)£¡£¡
ÒòΪ2003 ÆßÔ 2 11:23:17 ²»ÊDZê׼ʱ¼äÊäÈ룬http://www.gnu.org/manual/tar-1. ... οÉÒÔ³ÉΪ2003-07-02 11:23 µÄ±ê׼ʱ¼ä·µ»ØÖµ£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡

TOP

ÎÒÒ²Óöµ½ÄãÒ»ÑùµÄÎÊÌ⣬ÏÖÔÚûÓÐÕÒµ½½â¾ö°ì·¨£¬Ö»ÓдÓÊý¾Ý¿âselect
datepart(YY,a.thedate) as Y,datepart(m,a.thedate) as m,datepart(d,a.thedate) as d
È»ºóÔÙÁ¬½Ó×Ö´®Êä³ö......¡¡¡¡¡¡¡¡¡¡¡¡

TOP

·¢Ð»°Ìâ