代码搜索:datediff
找到约 324 项符合「datediff」的源代码
代码结果 324
www.eeworm.com/read/170321/9810394
h formula.h
/***************************************
Filename : formula.h
Version : Formula Language V1.1
Author : Shen Tu Hongnan
Modify :
Date : 2001/08/26
Remark :
********************
www.eeworm.com/read/240751/6783179
ʱ
select datediff(day,Deposit_date,getdate()) as ttot
from fund_bill
where card_type=:a and card_no=:b
www.eeworm.com/read/178467/9395369
txt updateuseronline.txt
/*
功能说明:自动更新用户在线状态,每20分钟更新一次
涉及数据对象:XT_TC_user
制做人:刘晓颖
制做日期:2003-1-15
*/
CREATE PROCEDURE pr_XT_UpdateUserOL
AS
BEGIN TRANSACTION UpdateUserOL
UPDATE XT_TC_USER SET 登录时间=''
WHERE datediff(
www.eeworm.com/read/169320/9866571
sql 2.5.4 计算工作时间的函数.sql
if exists (select * from dbo.sysobjects where id = object_id(N'[tb_worktime]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [tb_worktime]
GO
--定义工作时间表
CREATE TABLE tb_worktime(
ID
www.eeworm.com/read/311445/13631011
sql fine_sum.sql
CREATE PROCEDURE Fine_Sum
(@book_id int)
as
DECLARE @out_day int,@may_day smalldatetime,@Fine_Sum int
set @may_day=datediff(day,(select lend_time from lend_book WHERE book_id=@book_id),(select ret