Article View: cn.bbs.comp.database
Article #9182Re: ��һsql server������
From: tiancheng.bdwm.net
Date: Sat, 30 Aug 2003 03:35
Date: Sat, 30 Aug 2003 03:35
16 lines
1630 bytes
1630 bytes
sqlserver�п���ʹ��datediff���� �� �� jawahh.bbs@bbs.sjtu.edu.cn (�����ӽ�����....) �Ĵ������ᵽ: �� : Ҫ��ѯ����(��0�㵽24��)�Ľ��� : ���뵽������between����ѯ,��Ҫȡ�õ���0���datetime��� : ������һ������Ϊ�ܱ��ķ��� : select convert(datetime,convert(char,getdate(),102)) : ������Ȼ���Եõ�����0���datetime���,���ܾ��ò�̫������ô���� : �Dz���������? -- ������ҳ���Կ����� ��ӭ���ѷ��� http://tiancheng.bdwm.net [m[1;37m�� ��Դ:������δ��վ bbs.pku.edu.cn��[FROM: 162.105.52.105][m
Technical Details
Message-ID:
<484cTK$YS1@bbs.pku.edu.cn>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-08!supernews.com!38.144.126.76.MISMATCH!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!news2.happynet.org!news.happynet.org!PKUShow Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB X-Google-Thread: 101948,9843d50efa3b4179 X-Google-Attributes: gid101948,public X-Google-ArrivalTime: 2003-08-29 20:36:31 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-08!supernews.com!38.144.126.76.MISMATCH!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!news2.happynet.org!news.happynet.org!PKU From: tiancheng@bbs.pku.edu.cn (tiancheng.bdwm.net) Newsgroups: cn.bbs.comp.database Subject: Re: ��һsql server������ Date: 30 Aug 2003 03:35:47 GMT Organization: ����δ��վ Message-ID: <484cTK$YS1@bbs.pku.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: Database/M.1062214532.A Lines: 16