摘要：
SELECT to_char(TRUNC(SYSDATE,'mm'),'yyyy/mm/dd') FROM dual;SELECT to_char(last_day(SYSDATE),'yyyy/mm/dd') FROM dual 阅读全文
posted @ 2022-03-04 13:44
AaronLi
阅读(2301)
评论(0)
推荐(0)
摘要：
DEFINE l_format LIKE type_t.chr100 阅读全文
posted @ 2021-11-24 09:16
AaronLi
阅读(223)
评论(0)
推荐(0)
摘要：
SELECT ROWNUM,bmbaent,bmbasite, connect_by_root(bmaa001) root, bmba002,bmaa001,bmba003, LEVEL level1, sys_connect_by_path(LEVEL,'∠') level2 FROM bmaa_ 阅读全文
posted @ 2021-08-25 15:16
AaronLi
阅读(140)
评论(0)
推荐(0)
摘要：
SELECT to_date('2019-01-01\', 'yyyy-MM-dd\') + ROWNUM - 1 AS dateday FROM dual CONNECT BY ROWNUM <= (to_date('2021-08-24\', 'yyyy-MM-dd\') - to_date(' 阅读全文
posted @ 2021-08-23 15:39
AaronLi
阅读(751)
评论(0)
推荐(0)
摘要：
大概效果： 参考：https://echarts.apache.org/examples/zh/editor.html?c=pie-nest 前端： <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="axmt630zc.aspx.cs 阅读全文
posted @ 2021-08-11 15:12
AaronLi
阅读(266)
评论(0)
推荐(0)
摘要：
效果： 官网：https://echarts.apache.org/zh/index.html 前端web： <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Demo_1.aspx.cs" Inherits="WebApplicat 阅读全文
posted @ 2021-08-10 15:31
AaronLi
阅读(239)
评论(0)
推荐(0)
摘要：
效果图 前端web和axaj： <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="zichanmx.aspx.cs" Inherits="xsweb.ERPInfo.zichanmx" %> <!DOCTYPE html> <html 阅读全文
posted @ 2021-07-28 11:52
AaronLi
阅读(181)
评论(0)
推荐(0)
摘要：
<connectionStrings> <add name="oracle" connectionString="Data Source= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xx 阅读全文
posted @ 2021-07-28 11:40
AaronLi
阅读(450)
评论(0)
推荐(0)
摘要：
select dt,(Datepart(weekday,dt)-1) week from ( select convert(varchar(10),dateadd(dd,number,convert(varchar(8),getdate(),120)+'01'),120) as dt from ma 阅读全文
posted @ 2021-07-28 11:32
AaronLi
阅读(123)
评论(0)
推荐(0)
摘要：
转自：https://www.cnblogs.com/yuyexiaoxiao/p/13537101.html 案例一： string json = "[{"Groupid":"54","groupnum":"66000","groupname":"大唐移动","type":"0","dnspref 阅读全文
posted @ 2021-05-24 17:29
AaronLi
阅读(2069)
评论(0)
推荐(0)
浙公网安备 33010602011771号