代码搜索：DateTime
找到约 6,148 项符合「DateTime」的源代码
代码结果 6,148
www.eeworm.com/read/288405/4007353
sql 应收账龄分析_proc.sql
IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='应收账龄分析_PROC' AND TYPE='P')
DROP PROC 应收账龄分析_PROC
GO
create PROC 应收账龄分析_PROC
AS
create table #收款汇总
(发票号码 VARCHAR(20),
发票日期 DATETIME,
借方金额 NUM
www.eeworm.com/read/367917/2829932
mysql ui-dt.mysql
source ui-dt-CHECKBOX.sql;
source ui-dt-CURRENCY.sql;
source ui-dt-DATETIME.sql;
source ui-dt-DATE.sql;
source ui-dt-FILE.sql;
source ui-dt-HIDDEN.sql;
source ui-dt-MULTI_CHECKBOX.sql;
source u
www.eeworm.com/read/160745/5565946
˪-ii--
IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='应收账龄分析_PROC' AND TYPE='P')
DROP PROC 应收账龄分析_PROC
GO
create PROC 应收账龄分析_PROC
AS
create table #收款汇总
(发票号码 VARCHAR(20),
发票日期 DATETIME,
借方金额 NUM
www.eeworm.com/read/160745/5566039
˪
IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='应付账龄分析_PROC' AND TYPE='P')
DROP PROC 应付账龄分析_PROC
GO
create PROC 应付账龄分析_PROC
AS
create table #付款汇总
(发票号码 VARCHAR(20),
发票日期 DATETIME,
借方金额 NUM
www.eeworm.com/read/414839/11100169
sql 交叉表.sql
--示例
--示例数据
create table tb(ID int,Time datetime)
insert tb select 1,'2005/01/24 16:20'
union all select 2,'2005/01/23 22:45'
union all select 3,'2005/01/23 0:30'
union all select 4,'2005/01/2
www.eeworm.com/read/414392/11114563
sql 交叉表.sql
--示例
--示例数据
create table tb(ID int,Time datetime)
insert tb select 1,'2005/01/24 16:20'
union all select 2,'2005/01/23 22:45'
union all select 3,'2005/01/23 0:30'
union all select 4,'2005/01/2
www.eeworm.com/read/247504/12655106
sql 应收账龄分析_proc.sql
IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='应收账龄分析_PROC' AND TYPE='P')
DROP PROC 应收账龄分析_PROC
GO
create PROC 应收账龄分析_PROC
AS
create table #收款汇总
(发票号码 VARCHAR(20),
发票日期 DATETIME,
借方金额 NUM
www.eeworm.com/read/247504/12655713
sql 应付账龄分析_proc.sql
IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='应付账龄分析_PROC' AND TYPE='P')
DROP PROC 应付账龄分析_PROC
GO
create PROC 应付账龄分析_PROC
AS
create table #付款汇总
(发票号码 VARCHAR(20),
发票日期 DATETIME,
借方金额 NUM
www.eeworm.com/read/174902/9569899
sql 组合查询条件的存储过程.sql
/*
功能：查询每块水表的最后一次抄表时间，距指定时间超过指定值的记录
*/
-- declare @current_date datetime
-- set @current_date = getdate()
--
-- select *
-- from v_last_read_rec r
-- where datediff(day, r.read_time,@curre
www.eeworm.com/read/169320/9866598
sql 2.4.1 日期格式化处理.sql
DECLARE @dt datetime
SET @dt=GETDATE()
--1．短日期格式：yyyy-m-d
SELECT REPLACE(CONVERT(varchar(10),@dt,120),N'-0','-')
--2．长日期格式：yyyy年mm月dd日
--A. 方法1
SELECT STUFF(STUFF(CONVERT(char(8),@dt,112),