Re: ��SQL��ѯ��

Article View: cn.bbs.comp.database

Article #1381

Back to cn.bbs.comp.database Previous Next

#1381

From: ���Ϲ�
Date: Sun, 26 Aug 2007 15:32

17 lines
1914 bytes

    ������ַ������и���ʽת����
    �������set dateformat��ָ��������ڸ�ʽ��
    ���ߣ���Ҳ������ʾ���Ȱ�����ַ�ת�����������ͣ���convert��
�� �� 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;35m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 58.157.44.202][m

Technical Details

Message-ID: <4VdMYR$aiX@bbs.sjtu.edu.cn>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!club-internet.fr!feedme-small.clubint.net!194.25.134.62.MISMATCH!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!news.cn99.com!bbsnews.sdu.edu.cn!SJTUBBS

Show 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!news3.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!club-internet.fr!feedme-small.clubint.net!194.25.134.62.MISMATCH!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!news.cn99.com!bbsnews.sdu.edu.cn!SJTUBBS
From: tempdb.bbs@bbs.sjtu.edu.cn (������Ϲ�)
Newsgroups: cn.bbs.comp.database
Subject: Re: �������SQL��ѯ������
Date: 26 Aug 2007 15:32:27 GMT
Organization: ��ˮ˼Դ
Message-ID: <4VdMYR$aiX@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1188142203.A
Lines: 17

Article View: cn.bbs.comp.database

Re: �������SQL��ѯ������

Re: ��SQL��ѯ��