Article View: cn.bbs.comp.database
Article #1384Re: �������SQL��ѯ������
From: Hien
Date: Wed, 29 Aug 2007 03:52
Date: Wed, 29 Aug 2007 03:52
19 lines
1778 bytes
1778 bytes
Ҳ����˵������24Сʱ��ʱ���� �� �� zmh (�ս�) �Ĵ������ᵽ: �� : ��PM��AMȥ���Ϳ����� : �� �� HienChu �Ĵ������ᵽ: �� : : SELECT * : : FROM ʵ�ʻ��Ϲ��� : : WHERE (������ = '1245.6') AND (����ʱ�� > '2007-6-20 PM 06:10:00') AND : : (����ʱ�� < '2007-6-21 AM 08:10:00') : : ORDER BY ����ʱ�� : : ��������varchar����С30��������ʱ����datetime����С8���� : : ��SQL 2000�д?ʵ�ʻ��Ϲ������������ѯ��䣬���г������´��� : : ����char ������͵�datetime ������͵�ת������datetime ֵԽ�硱 : .................������ʡ�ԣ� -- Heart Is Ever Near! [m[1;36m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 59.78.22.125][m
Technical Details
Message-ID:
<4VfL2T$c8W@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!news.cn99.com!bbsnews.sdu.edu.cn!SJTUBBSShow Full Headers
Complete Article Headers
X-Google-Thread: 101948,dd9ea1f53852b55c,start X-Google-Attributes: gid101948,public,usenet X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!news.cn99.com!bbsnews.sdu.edu.cn!SJTUBBS From: HienChu.bbs@bbs.sjtu.edu.cn (Hien) Newsgroups: cn.bbs.comp.database Subject: Re: �������SQL��ѯ������ Date: 29 Aug 2007 03:52:58 GMT Organization: ��ˮ˼Դ Message-ID: <4VfL2T$c8W@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1188359549.A Lines: 19