易截截图软件、单文件、免安装、纯绿色、仅160KB

sql日期模糊查询 SQL时间转换格式

Select * from t_user_profile where convert ( varchar ( 21 ),regDate, 120 ) like ' 2008-05-07% ' 表名称:t_user_profile 日期字段名称:regDate
Select   *   from t_user_profile  where  convert(varchar(21),regDate,120) like '2008-05-07%'
表名称:t_user_profile
日期字段名称:regDate
(责任编辑:admin)
 
 
 
select Convert( varchar(20) , 时间字段 , 格式 ) from 表 如:select Convert(varchar(20),LOGIN_DATE,112) from dbo.C_PARTY_CLIENT 100:Jun 22 2009 12:00AM 101:06/22/2009 102:2009.06.22 103:22/06/2009 104:22.06.2009 105:22-06-2009 106:22
select Convert(varchar(20),<时间字段>,<格式>) from <表>
如:select Convert(varchar(20),LOGIN_DATE,112) from dbo.C_PARTY_CLIENT
100:Jun 22 2009 12:00AM
101:06/22/2009
102:2009.06.22
103:22/06/2009
104:22.06.2009
105:22-06-2009
106:22 Jun 2009
107:Jun 22, 2009
108:00:00:00
109:Jun 22 2009 12:00:00
110:06-22-2009
111:2009/06/22
112:20090622
113:22 Jun 2009 00:00:00
114:00:00:00:000
120:2009-06-22 00:00:00.
126:2009-06-22T00:00:00
127:2009-06-22T00:00:00
131:29/06/1430 12:00:00:
 附上时间比较:
SELECT * from [TABLE] where   convert(varchar(10),<时间字段>,111) = @Time
SELECT * from ManualSign where  SignTime  BETWEEN  convert(datetime,@beginTime )  AND  convert(datetime,@endTime)
希望对大家有帮助。
 


相关文档:

MS SQL 2000/2005 修改表所有者存储过程

Create PROCEDURE [dbo].[ChangeObjectOwner]
@OldOwner as NVARCHAR(128),
@NewOwner as NVARCHAR(128)
AS
DECLARE @Name   as NVARCHAR(128)
DECLARE @Owner  as NVARCHAR(128)
DECLARE @OwnerName as NVARCHAR(128)
DECLARE curObject CURSOR FOR
select 'Name' = name,
 'Owner'&n ......

SQL Server SQL语句导入导出大全

/*******  导出到excel
EXEC master..xp_cmdshell ’bcp SettleDB.dbo.shanghu out c:\temp1.xls -c -q -S"GNETDATA/GNETDATA" -U"sa" -P""’
/***********  导入Excel
SELECT *
from OpenDataSource( ’Microsoft.Jet.OLEDB.4.0’,
  ’Data Source="c:\test.xls";User ......

v$sql,v$sqlarea,v$sqltext有什么区别

http://inthirties.com:90/thread-1202-1-1.html
v$sqltext
存储的是完整的SQL,SQL被分割
SQL> desc v$sqltext
Name Null? Type
----------------------------------------- -------- ----------------------------
ADDRESS ......

SQL语句查询是否为空 =null及null

  a                  b                             c&nb ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号