Sql Server\ MySql 日期
------------------MS Sql Server------------------
declare @ctrBeginTime =null;
if(@ctrBeginTime Is NUll)
begin
set @ctrBeginTime= GETDATE();
end
declare @statisticsDate as datetime = CONVERT(varchar(10),@ctrBeginTime,120); /*统计时间*/
declare @ThisYear1stDay as datetime = DATEADD(yy, DATEDIFF(yy,0,@statisticsDate),0); /*本年的第一天*/
declare @LastYearLastDay as datetime = DATEADD(dd,-1,@ThisYear1stDay); /*去年的最后一天*/
declare @LastYear1stDay as datetime = DATEADD(yy, DATEDIFF(yy,0,@LastYearLastDay),0); /*去年的第一天*/
set @beginTime = DATEADD(mm,DATEDIFF(mm,0,DATEADD(MONTH,-1,GETDATE())),0)--上月第一天
set @endTime = DATEADD(ms,-3,DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0))--上月最后一天
CONVERT(char(6), GETDATA(),112) as CourseDateYM ------------------MySQL------------------
DECLARE _DateTimeNow DATETIME DEFAULT NOW();
DECLARE _CurYear INT DEFAULT YEAR(CURRENT_DATE());
DECLARE _CurMonth INT DEFAULT MONTH(CURRENT_DATE());
DECLARE _Month_First_Day DATETIME default CAST(CONCAT(DATE_FORMAT(now(),"%Y.%m."),"01 00:00:00") AS datetime);
DECLARE _Month_Last_Day DATETIME default CAST(CONCAT(LAST_DAY(now())," 23:59:59") AS datetime);
SELECT str_to_date('2019-05-01','%Y-%m-%d')
SELECT CAST(CONCAT(DATE_FORMAT(str_to_date('2019-05-01','%Y-%m-%d'),"%Y.%m."),"01 00:00:00") AS datetime);
SELECT LAST_DAY(NOW()); #本月最后一天
最新文章
- Unity3d动画脚本 Animation Scripting(深入了解游戏引擎中的动画处理原理)
- xgboost中如何自定义metric(python中)
- 设置mysql数据库的密码
- #include <;assert.h>;
- RobotFramework环境搭建
- URAL 1141. RSA Attack RSA加密演算法
- 常用js功能函数汇总(持续更新ing)
- 转载 Elasticsearch开发环境搭建(Eclipse\MyEclipse + Maven)
- openfire推送离线聊天信息的插件
- hdu1256
- GitHub上README.md编写教程(基本语法)
- 分布式Tomcat session会话Sticky Sessions问题
- [luogu1486][bzoj1503][NOI2004]郁闷的出纳员【平衡树treap】
- Java多线程中对CountDownLatch的使用
- hashCode()方法与equals()方法
- [Vue warn]: You are using the runtime-only build of Vue where the template compiler is not available. Either pre-compile the templates into render functions, or use the compiler-included build.
- hdu1242Rescue
- bzoj1013球形空间
- Android WiFi热点7.1以上版本适配
- LabVIEW初篇---前言