--Trunc ,Round return date
-- To_char returns String
-- month length
select trunc(add_Months(trunc(sysdate, 'mm'), 1), 'mm') -
trunc(sysdate, 'mm')
from dual;
select trunc(add_Months(trunc(to_date('&V','yyyy-mm-dd'), 'mm'), 1), 'mm') -
trunc(to_date('&V','yyyy-mm-dd'), 'mm')
from dual;
ALTER SESSION SET NLS_DATE_LANGUAGE = 'AMERICAN';
-- 2010-02-01 IS Monday
-- 2010-03-01 is Monday
select next_day(TO_date('2010-02-27','yyyy-mm-dd'),'MONDAY' ) from dual; -- 2010-03-01 it shows next month!
select next_day( trunc( TO_date('2010-02-27','yyyy-mm-dd'),'mm'),'MONDAY' ) from dual; -- 2010-02-08 incorrect ;actually 2010-02-01 is first monday for month
select next_day(trunc(TO_date('2010-02-27', 'yyyy-mm-dd'), 'mm') - 1,
'MONDAY')
from dual; -- 2010-02-01 correct first monday of month
select next_day(trunc(TO_date('2010-02-27', 'yyyy-mm-dd'), 'mm') - 1,
'MONDAY')+2*7
from dual; -- 2010-02-01 correct third monnday of month
select next_day(trunc(TO_date('&V', 'yyyy-mm-dd'), 'mm') - 1,
'MONDAY')+(&SEQUENCE-1)*7
from dual; -- 2010-02-01 correct third monnday of month
select trunc (sysdate ,'Q') from dual;
select to_char(sysdate,'Q') from dual;
分享到:
相关推荐
11、时间和日期功能(Time and Date Function) 23 12、鼠标功能中断INT 33H.. 24 13、其它DOS中断... 31 BIOS中断: 33 1、显示服务(Video Service——INT 10H) 33 2、直接磁盘服务(Direct Disk Service——INT ...
还支持对各种特殊数据类型 如Date Function Array Object DOM json等 的格式化输出 ">关于logger2js Version:v1 0 6 创意无限 简单实用 javascript logger&debug toolbox logger2js logger2js是用原生态...
此 J2ME 应用程序有助于为日期添加天数,或计算两个日期之间的天数。
职能 // Datefunction dateToMysql([date=new Date()])function dateToString([date=new Date()])function now()function cloneDate(date)// Arrayfunction arrayChunk(array, chunkSize)function sort(array, ...
自己总结的,DB2日期函数的处理经验和转换语法,值得一看
Date对象有个getDay方法,它根据本地时间,返回一个具体日期中一周的第几天。返回值从0~6,分别对应周日~周六 getDay 0 1 2 3 4 5 6 星期几 周日 周一 周二 周三 周四 周五...function getChineseWeekByD
Namespace xFunction Public Class f Const NumList = "零壹贰叁肆伍陆柒捌玖" Const UnitList = "仟佰拾亿仟佰拾万仟佰拾元角分" Public Shared Sub StringList() Dim tmepList As New List(Of String) ...
book 对对应的字段注册操作,如果有date类型数据注入的时候会引用我们新建的规则 SpringMVC_Coustom_json_Date_Deserializer.jara 是我们需要... success: function(data) { console.info(data) } });
本文转自:http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html#function_date-format DATE_FORMAT(date,format) Formats the date value according to the format string. The following ...
日期移位功能 y = [0-9] | m = [0-9] | w = [0-9] | d = [0-9] | pos =“ floor”,aggr =“ year” | “回滚” date_shift(今天,y = 1,pos =“ floor”,aggr =“ week”)
本文实例讲述了JS使用Date对象实时显示当前系统时间的方法。分享给大家供大家参考,具体如下: JS中包含Date对象,其提供了一些方法获取系统日期,... function realSysTime(clock) { var now = new Date(); var year
php报时区错误,按照网上说的改时间date.timezone... You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still
format date time underline for vb6 in function for filenames
// 对Date的扩展,将 Date 转化为指定格式的String // 月(M)、日(d)、小时(h)、分(m)、秒(s)、季度(q) 可以用 1-2 个占位符, // 年(y)可以用 1-4 个占位符,毫秒(S)只能用 1 个占位符(是 1-3 位的数字) // 例子: /...
* 将型如"20191018123030"转为"2019-10-18 ... import {formatDateSep} from "@/common/js/date.js"; // 时间戳转换 filters: { timeStamp: function(value) { return formatDateSep(value, "-"); } },
微信小程序 时间格式化 微信小程序虽然还在内测,但是...function formatTime(date) { var year = date.getFullYear() var month = date.getMonth() + 1 var day = date.getDate() var hour = date.getHours() var
代码如下:// 和PHP一样的时间戳格式化函数// @param {string} format 格式// @param {int} timestamp 要格式化的时间 默认为当前时间// @return {string} 格式化的时间字符串function date ( format, timestamp...
纠结老长时间,放弃了new date 然后再老外的论坛中找了一段段代码可以兼容所有浏览器的格式化日期代码: 代码如下: function NewDate(str) { str = str.split(‘-‘); var date = new Date(); date.setUTCFullYear...
近来总是有系统邮件提示,... You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still gett ing this warni
This date class consists of lots of function like calculation of age, difference between two dates, Adding number to a date and subtracting and also checking whether the date is valid or not and so on