Article View: cn.bbs.comp.database
Article #1379�������SQL��ѯ������
From: Hien
Date: Sat, 25 Aug 2007 11:34
Date: Sat, 25 Aug 2007 11:34
17 lines
1483 bytes
1483 bytes
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 ֵԽ�硱
�����ָ�̣�
��л�ˡ���
--
[0;1;35m������?[m
[m[1;34m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 59.78.22.125][m
Technical Details
Message-ID:
<4VcR13$auc@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!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,afeaacd215110fa1,start X-Google-Attributes: gid101948,public,usenet X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!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: �������SQL��ѯ������ Date: 25 Aug 2007 11:34:55 GMT Organization: ��ˮ˼Դ Message-ID: <4VcR13$auc@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1188041523.A Lines: 17