🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.database
Article #8902

Access����α�ʾʱ�䳣��

#8902
From: ����~~CRT VS LCD
Date: Sun, 21 Sep 2003 09:34
11 lines
1366 bytes
�����Ҳ���Access��SQL����ֲᡣ
�ҵĻ����Ͽ����õ���ű�ʾʱ�䳣�����
select * from table1 where dateColumn>'2003-9-20 8:05:10'
Ҳ�����þ��ñ�ʾ�����磺
select * from table1 where dateColumn>#2003-9-20 8:05:10#
�������ԱߵĻ���ֻ����#�������õ���ţ�
��̨���������������һ����Access2000��OleDb 4.0

--
http://bbs.nankai.edu.cn/file/Dotnet/cdrom.jpg
�� ��Դ:���Ұ��Ͽ�վ bbs.nankai.edu.cn��[FROM: 219.150.100.43] 
Technical Details
Message-ID: <48M8iG$ZKB@bbs.nankai.edu.cn>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!newsfeed.news2me.com!elnk-nf2-pas!newsfeed.earthlink.net!sjc70.webusenet.com!news.webusenet.com!maily.cic.tsinghua.edu.cn!news.happynet.org!NanKai

Show Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB
X-Google-Thread: 101948,9eabafa70e080f4f,start
X-Google-Attributes: gid101948,public
X-Google-ArrivalTime: 2003-09-21 02:37:37 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!newsfeed.news2me.com!elnk-nf2-pas!newsfeed.earthlink.net!sjc70.webusenet.com!news.webusenet.com!maily.cic.tsinghua.edu.cn!news.happynet.org!NanKai
From: Monsters.bbs@bbs.nankai.edu.cn (����~~CRT VS LCD)
Newsgroups: cn.bbs.comp.database
Subject: Access����α�ʾʱ�䳣��
Date: 21 Sep 2003 09:34:26 GMT
Organization: �Ұ��Ͽ�վ
Message-ID: <48M8iG$ZKB@bbs.nankai.edu.cn>
X-Filename: Database/M.1064136784.A
Lines: 11