Re: ��

Article View: cn.bbs.comp.database

Article #8818

Back to cn.bbs.comp.database Previous Next

#8818

From: ��ݽṹvsƫ΢
Date: Fri, 17 Oct 2003 11:30

34 lines
2216 bytes

create procedure pro_savetime
@the_time datetime
as
begin
   insert into table_name(...) where ...
end
ת��time_tΪ�ַ�ʱ���ʽs_time��Ȼ��
sprintf(buf,"exec pro_savetime '%s'",s_time);
c���Ե��ô洢���

˼���������SQL Server�Ĵ洢��̲�������Զ�����ת��
hoho

�� �� monica (monica) �Ĵ������ᵽ: ��
: 
: �ڱ�дһ��SQLSERVER�Ĵ洢����У�����Ҫ�Ƚ�2�����ڵĴ�С��
: 
: ��Ҫ��������C���Եõ���time_t����ֵ��Ȼ����INT���ʹ�����ݿ���ֵת����DATETI
: 
: ME���ͣ�
: ���ʣ�SQLSERVER��û�к����ṩ֮���ת����
: 
: ��л��
: 


--
           ������                       ��                                    
         ��������                     �v����                                  
       ����             �q�Щ�      ��������                                  
     �q����             /�q����  �r   ����   ������Ҷ����Ʈ�����������?      
     �t�r��  �q�r�q�r�q�s�t�������s                                           
       �t�����s�t�s�t�s                                                         
[m[1;36m�� ��Դ:���Ұ��Ͽ�վ bbs.nankai.edu.cn��[FROM: 10.10.117.44][m

Technical Details

Message-ID: <48gQZg$ZqB@bbs.nankai.edu.cn>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!maily.cic.tsinghua.edu.cn!news.happynet.org!NanKai

Show Full Headers

Complete Article Headers

X-Google-Language: Chinese,GB
X-Google-Thread: 101948,2999e14b45f58369,start
X-Google-Attributes: gid101948,public
X-Google-ArrivalTime: 2003-10-17 04:35:12 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!maily.cic.tsinghua.edu.cn!news.happynet.org!NanKai
From: opoopo.bbs@bbs.nankai.edu.cn (��ݽṹvsƫ΢)
Newsgroups: cn.bbs.comp.database
Subject: Re: �����
Date: 17 Oct 2003 11:30:22 GMT
Organization: �Ұ��Ͽ�վ
Message-ID: <48gQZg$ZqB@bbs.nankai.edu.cn>
X-Filename: Database/M.1066389690.A
Lines: 34

Article View: cn.bbs.comp.database

Re: �����

Re: ��