BlogJava-JAVA AJAX C++-最新评论http://www.blogjava.net/itspy/CommentsRSS.aspxzh-cnTue, 15 Dec 2009 04:36:41 GMTTue, 15 Dec 2009 04:36:41 GMTcnblogsre: JDBC连接Oracle数据库时出现的ORA-12505错误及解决办法 http://www.blogjava.net/itspy/archive/2009/12/17/169072.html#306382goodguyzlgoodguyzlThu, 17 Dec 2009 09:39:00 GMThttp://www.blogjava.net/itspy/archive/2009/12/17/169072.html#306382

goodguyzl 2009-12-17 17:39 发表评论
]]>re: 如何删除Windows Search http://www.blogjava.net/itspy/archive/2009/08/27/280043.html#292903升级原因升级原因Thu, 27 Aug 2009 13:16:00 GMThttp://www.blogjava.net/itspy/archive/2009/08/27/280043.html#292903

升级原因 2009-08-27 21:16 发表评论
]]>re: oracle的to_char函数(转)http://www.blogjava.net/itspy/archive/2009/08/10/213949.html#290554itspyitspyMon, 10 Aug 2009 07:50:00 GMThttp://www.blogjava.net/itspy/archive/2009/08/10/213949.html#290554select CONVERT (varchar, convert(datetime, '2009-04-23'), 101 )
select CONVERT (varchar, convert(datetime, '2009-04-23'), 102 )
select CONVERT (varchar, convert(datetime, '2009-04-23'), 103 )
select CONVERT (varchar, convert(datetime, '2009-04-23'), 104 )
select CONVERT (varchar, convert(datetime, '2009-04-23'), 105 )
select CONVERT (varchar, convert(datetime, '2009-04-23'), 106 )
select CONVERT (varchar, convert(datetime, '2009-04-23'), 107 )
select CONVERT (varchar, convert(datetime, '2009-04-23'), 108 )
select CONVERT (varchar, convert(datetime, '2009-04-23'), 9 )
select CONVERT (varchar, convert(datetime, '2009-04-23'), 110 )
select CONVERT (varchar, convert(datetime, '2009-04-23'), 111 )
select CONVERT (varchar, convert(datetime, '2009-04-23'), 112 )
select CONVERT (varchar, convert(datetime, '2009-04-23'), 13 )
select CONVERT (varchar, convert(datetime, '2009-04-23'), 114 )
select CONVERT (varchar, convert(datetime, '2009-04-23'), 20 )
select CONVERT (varchar, convert(datetime, '2009-04-23'), 21 )
select CONVERT (varchar, convert(datetime, '2009-04-23'), 126 )
select CONVERT (varchar, convert(datetime, '2009-04-23'), 130 )
select CONVERT (varchar, convert(datetime, '2009-04-23'), 131 )

itspy 2009-08-10 15:50 发表评论
]]>re: oracle的to_char函数(转)http://www.blogjava.net/itspy/archive/2009/08/10/213949.html#290551itspyitspyMon, 10 Aug 2009 07:38:00 GMThttp://www.blogjava.net/itspy/archive/2009/08/10/213949.html#290551Apr 23 2009



itspy 2009-08-10 15:38 发表评论
]]>re: jQuery笔记－插件开发小技巧[未登录]http://www.blogjava.net/itspy/archive/2009/06/04/180521.html#280084snowsnowThu, 04 Jun 2009 13:59:00 GMThttp://www.blogjava.net/itspy/archive/2009/06/04/180521.html#280084

snow 2009-06-04 21:59 发表评论
]]>re: oracle的to_char函数(转)http://www.blogjava.net/itspy/archive/2009/04/23/213949.html#267143itspyitspyThu, 23 Apr 2009 06:36:00 GMThttp://www.blogjava.net/itspy/archive/2009/04/23/213949.html#2671432009-04-23


select cast( getDate() AS varchar(11))
Apr 22 2009


itspy 2009-04-23 14:36 发表评论
]]>re: oracle的to_char函数(转)http://www.blogjava.net/itspy/archive/2009/04/23/213949.html#267140itspyitspyThu, 23 Apr 2009 06:29:00 GMThttp://www.blogjava.net/itspy/archive/2009/04/23/213949.html#267140
select CONVERT(varchar(10),getDate(),126)

2009-04-23

itspy 2009-04-23 14:29 发表评论
]]>re: oracle日期函数集锦http://www.blogjava.net/itspy/archive/2009/03/11/213944.html#259199itspyitspyWed, 11 Mar 2009 11:30:00 GMThttp://www.blogjava.net/itspy/archive/2009/03/11/213944.html#259199http://www.sqlserver.com.cn/c2l0ZS9zaG93Lmh0bWw_bXlpZD0yMDY=url.html


1.一个月第一天的
SELECT DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)

2.本周的星期一
SELECT DATEADD(wk, DATEDIFF(wk,0,getdate()), 0)

3.一年的第一天
SELECT DATEADD(yy, DATEDIFF(yy,0,getdate()), 0)

4.季度的第一天
SELECT DATEADD(qq, DATEDIFF(qq,0,getdate()), 0)

5.当天的半夜
SELECT DATEADD(dd, DATEDIFF(dd,0,getdate()), 0)

6.上个月的最后一天
SELECT dateadd(ms,-3,DATEADD(mm, DATEDIFF(mm,0,getdate()), 0))

7.去年的最后一天
SELECT dateadd(ms,-3,DATEADD(yy, DATEDIFF(yy,0,getdate()), 0))

8.本月的最后一天
SELECT dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate())+1, 0))

9.本年的最后一天
SELECT dateadd(ms,-3,DATEADD(yy, DATEDIFF(yy,0,getdate())+1, 0))

10.本月的第一个星期一
select DATEADD(wk, DATEDIFF(wk,0,dateadd(dd,6-datepart(day,getdate()),getdate())), 0)


itspy 2009-03-11 19:30 发表评论
]]>re: 解决EXCEL不能求和运算http://www.blogjava.net/itspy/archive/2009/03/06/244962.html#258117yayayayaFri, 06 Mar 2009 01:35:00 GMThttp://www.blogjava.net/itspy/archive/2009/03/06/244962.html#258117

yaya 2009-03-06 09:35 发表评论
]]>re: oracle的to_char函数(转)http://www.blogjava.net/itspy/archive/2009/02/19/213949.html#255418itspyitspyThu, 19 Feb 2009 03:26:00 GMThttp://www.blogjava.net/itspy/archive/2009/02/19/213949.html#255418
修改密码

itspy 2009-02-19 11:26 发表评论
]]>