Article View: cn.bbs.comp.database
Article #1380Re: �������SQL��ѯ������
From: ��ˮһ��
Date: Sun, 26 Aug 2007 07:01
Date: Sun, 26 Aug 2007 07:01
25 lines
2275 bytes
2275 bytes
���Ǹ��֡� �����û���������Excel��Matlab���棬ʱ��ȴ�Сʱ������"Serial Number"�� �ȵģ�����ʱ��"2007-6-21 AM 08:10:00"�ij�Ψһ��һ����ֵ������Ŀǰ�Բ�ͬ����ʼ ʱ����Ϊ0����������������Excel���õı�������ʱ��Ķ�Ӧֵ��"39254.340277 7778"���������һ�¡� �� �� HienChu (Hien) �Ĵ������ᵽ: �� : 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 ֵԽ�硱 : �����ָ�̣� : ��л�ˡ��� -- ħŮ����ʿ����ʿ���� ������֮·���Լ��� ��ͷ�����˼䣬��ͷ�ܹ����Լ������� [m[1;33m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 202.120.48.199][m
Technical Details
Message-ID:
<4Vd9Ec$aSd@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!198.186.194.247.MISMATCH!news-out.readnews.com!news-xxxfer.readnews.com!panix!bloom-beacon.mit.edu!news.cn99.com!bbsnews.sdu.edu.cn!SJTUBBSShow Full Headers
Complete Article Headers
X-Google-Thread: 101948,afeaacd215110fa1 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!nx01.iad01.newshosting.com!newshosting.com!198.186.194.247.MISMATCH!news-out.readnews.com!news-xxxfer.readnews.com!panix!bloom-beacon.mit.edu!news.cn99.com!bbsnews.sdu.edu.cn!SJTUBBS From: Waterside.bbs@bbs.sjtu.edu.cn (��ˮһ��) Newsgroups: cn.bbs.comp.database Subject: Re: �������SQL��ѯ������ Date: 26 Aug 2007 07:01:54 GMT Organization: ��ˮ˼Դ Message-ID: <4Vd9Ec$aSd@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1188111302.A Lines: 25