Article View: cn.bbs.comp.database
Article #8643Re: ��access��Ϊʲô������sql���Բ��ȥʱ��/������?
From: ����IJ��
Date: Sat, 01 Nov 2003 08:16
Date: Sat, 01 Nov 2003 08:16
19 lines
1576 bytes
1576 bytes
there is no convert function in access you could make it as follows: insert into messages values(1,#2003-10-31 12:52:13#) �� �� fireflyjava (��һ�������) �Ĵ������ᵽ: �� : insert into messages values(1,convert(datetime,2003-10-31 12:52:13)) : convert(datetime,2003-10-31 12:52:13) : ��access��Ϊʲô���ܲ��ȥʱ��/������ : ��sql2000����ѽ -- ���аٻ������£��������綬��ѩ�� �������¹���ͷ�������˼��ʱ�ڡ� [m[1;36m�� ��Դ:������δ��վ bbs.pku.edu.cn��[FROM: 162.105.222.173][m
Technical Details
Message-ID:
<4968HZ$ZO2@bbs.pku.edu.cn>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!news-xfer2.atl.newshosting.com!63.218.45.10.MISMATCH!newshosting.com!news-xfer1.atl.newshosting.com!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!news.happynet.org!PKUShow Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB X-Google-Thread: 101948,3cf6f9168a4b77dd,start X-Google-Attributes: gid101948,public X-Google-ArrivalTime: 2003-11-01 00:17:06 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!news-xfer2.atl.newshosting.com!63.218.45.10.MISMATCH!newshosting.com!news-xfer1.atl.newshosting.com!feed2.newsreader.com!newsreader.com!maily.cic.tsinghua.edu.cn!news.happynet.org!PKU From: thompson@bbs.pku.edu.cn (����IJ��) Newsgroups: cn.bbs.comp.database Subject: Re: ��access��Ϊʲô������sql���Բ��ȥʱ��/������? Date: 01 Nov 2003 08:16:49 GMT Organization: ����δ��վ Message-ID: <4968HZ$ZO2@bbs.pku.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: Database/M.1067674451.A Lines: 19