Article View: cn.bbs.comp.database
Article #9184Re: ��һsql server������
From: �����ӽ�����....
Date: Sat, 30 Aug 2003 03:55
Date: Sat, 30 Aug 2003 03:55
14 lines
1763 bytes
1763 bytes
��ô��? datediffֻ�Ƿ����������ڼ�ʱ��߽��� ����Ҳֻ��ָ��day����year֮��� �� �� tiancheng@bbs.pku.edu.cn (tiancheng.bdwm.net) �Ĵ������ᵽ: �� : sqlserver�п���ʹ��datediff���� : �� �� jawahh.bbs@bbs.sjtu.edu.cn (�����ӽ�����....) �Ĵ������ᵽ: �� : : Ҫ��ѯ����(��0�㵽24��)�Ľ��� : : ���뵽������between����ѯ,��Ҫȡ�õ���0���datetime��� : : ������һ������Ϊ�ܱ��ķ��� : : select convert(datetime,convert(char,getdate(),102)) : : ������Ȼ���Եõ�����0���datetime���,���ܾ��ò�̫������ô���� : : �Dz���������? -- [m[1;35m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 211.80.90.109][m
Technical Details
Message-ID:
<484d4e$ayX@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-04!sn-xit-06!sn-xit-09!supernews.com!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!newsgate.cuhk.edu.hk!news.zixia.net!news.neu.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB X-Google-Thread: 101948,9843d50efa3b4179 X-Google-Attributes: gid101948,public X-Google-ArrivalTime: 2003-08-29 20:58:06 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-04!sn-xit-06!sn-xit-09!supernews.com!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!newsgate.cuhk.edu.hk!news.zixia.net!news.neu.edu.cn!SJTU From: jawahh.bbs@bbs.sjtu.edu.cn (�����ӽ�����....) Newsgroups: cn.bbs.comp.database Subject: Re: ��һsql server������ Date: 30 Aug 2003 03:55:51 GMT Organization: ��ˮ˼Դ Message-ID: <484d4e$ayX@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1062215656.A Lines: 14