Article View: cn.bbs.comp.database
Article #9183Re: ��һsql server������
From: �����ӽ�����....
Date: Sat, 30 Aug 2003 03:53
Date: Sat, 30 Aug 2003 03:53
15 lines
1617 bytes
1617 bytes
û�������ƹ���..... �� �� hongliang (����) �Ĵ������ᵽ: �� : �ϴ�sql server���õIJ��࣬�����mysql�Ļ����һ���ôд : select * from table1 : where : data_datetime >= date_format(now(), '%Y-%m-%d 00:00:00') : and : data_datetime < date_format(now(), '%Y-%m-%d 01:00:00') : �� �� jawahh (�����ӽ�����....) �Ĵ������ᵽ: �� : : Ҫ��ѯ����(��0�㵽24��)�Ľ��� : : ���뵽������between����ѯ,��Ҫȡ�õ���0���datetime��� : : ������һ������Ϊ�ܱ��ķ��� : .................������ʡ�ԣ� -- [m[1;35m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 211.80.90.109][m
Technical Details
Message-ID:
<484d3Y$aOW@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!38.144.126.76.MISMATCH!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!news.neu.edu.cn!SJTUShow 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:53:17 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!38.144.126.76.MISMATCH!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!news.neu.edu.cn!SJTU From: jawahh.bbs@bbs.sjtu.edu.cn (�����ӽ�����....) Newsgroups: cn.bbs.comp.database Subject: Re: ��һsql server������ Date: 30 Aug 2003 03:53:33 GMT Organization: ��ˮ˼Դ Message-ID: <484d3Y$aOW@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1062215602.A Lines: 15