select 
	switch(
		Weekday(now)=1,'日'
		,Weekday(now)=2,'月'
		,Weekday(now)=3,'火'
		,Weekday(now)=4,'水'
		,Weekday(now)=5,'木'
		,Weekday(now)=6,'金'
		,Weekday(now)=7,'土'
	) as 曜日1
	,switch(
		Weekday(now,2)=1,'月'
		,Weekday(now,2)=2,'火'
		,Weekday(now,2)=3,'水'
		,Weekday(now,2)=4,'木'
		,Weekday(now,2)=5,'金'
		,Weekday(now,2)=6,'土'
		,Weekday(now,2)=7,'日'
	) as 曜日2;

select
	GETDATE() + 1 as 日数加算1
	,DATEADD(d, 1, GETDATE()) as 日数加算2
	,DATEADD(m, -1, GETDATE()) as 月数加算
	,DATEADD(yy, 1, GETDATE()) as 年数加算
	,DATEADD(ww, -1, GETDATE()) as 週数加算
	,DATEDIFF(d, '2005/01/01', GETDATE()) as 経過日数
	,DATEPART(d, GETDATE()) as 日
	,DATEPART(y, GETDATE()) as 年間通算日
	,DATEPART(hh, GETDATE()) as 時
	,DATEPART(n, GETDATE()) as 分
	,DATEPART(s, GETDATE()) as 秒
	,DATEPART(ms, GETDATE()) as milli秒
	,DATEPART(m, GETDATE()) as 月
	,DATEPART(w, GETDATE()) as 曜日
	,DATEPART(ww, GETDATE()) as 週
	,DATEPART(yyyy, GETDATE()) as 年
	,CONVERT(varchar, GETDATE(),120) as 日付編集1
	,CONVERT(varchar, GETDATE(),111) as 日付編集2
	,CONVERT(varchar, GETDATE(),11) as 日付編集3
	,CONVERT(varchar, GETDATE(),112) as 日付編集2
	,CONVERT(varchar, GETDATE(),12) as 日付編集3

select 
	NOW() + INTERVAL 1 DAY as 日数加算1
	,DATE_ADD(NOW(),INTERVAL 1 DAY) as 日数加算2
	,DATE_ADD(NOW(),INTERVAL -1 MONTH) as 月数加算
	,DATE_ADD(CURDATE(),INTERVAL 1 YEAR) as 年数加算
	,TO_DAYS(NOW()) - TO_DAYS(CAST('2005/01/01' as DATETIME)) as 経過日数
	,DATE_FORMAT(NOW(),'%d') as 日
	,DATE_FORMAT(NOW(),'%j') as 年間通算日
	,DAYOFYEAR(NOW()) as 年間通算日
	,DATE_FORMAT(NOW(),'%H') as 時
	,DATE_FORMAT(NOW(),'%i') as 分
	,DATE_FORMAT(NOW(),'%S') as 秒
	,DATE_FORMAT(NOW(),'%m') as 月
	,DATE_FORMAT(NOW(),'%w') as 曜日
	,DATE_FORMAT(NOW(),'%U') as 週
	,DATE_FORMAT(NOW(),'%Y') as 年
	,DATE_FORMAT(NOW(),'%Y-%m-%d') as 日付

select
	now(),localtime
	,now() + interval '1 day' as 日数加算
	,now() + interval '-1 month' as 日数加算
	,now() + interval '1 year' as 年数加算
	,current_date - '2005/01/01' as 経過日数
	,date_part('day', now()) as 日
	,date_part('doy', now()) as 年間通算日
	,date_part('hour', now()) as 時
	,date_part('minute', now()) as 分
	,date_part('second', now()) as 秒
	,date_part('milliseconds', now()) as milli秒
	,date_part('month', now()) as 月
	,date_part('dow', now()) as 曜日
	,date_part('week', now()) as 週
	,date_part('year', now()) as 年
	,to_char(now(), 'YYYY/MM/DD HH24:MI:SS') as 日付文字列1
	,to_char(now(), 'YYYY/FMMM/FMDD FMHH24:FMMI:FMSS') as 日付文字列2

select
	sysdate
	,sysdate + 1 as 日数加算
	,ADD_MONTHS( sysdate, -1 ) as 月数加算 
	,ADD_MONTHS( sysdate, 1 * 12 ) as 年数加算 
	,TRUNC(sysdate)-TO_DATE('2005/01/01') as 経過日数
	,EXTRACT(day from sysdate) as 日
	,EXTRACT(month from sysdate) as 月
	,EXTRACT(year from sysdate) as 年
	,TO_CHAR(sysdate,'HH24') as 時
	,TO_CHAR(sysdate,'MI') as 分
	,TO_CHAR(sysdate,'SS') as 秒
	,TO_CHAR(sysdate,'DDD') as 年間通算日
	,TO_CHAR(sysdate,'D') as 曜日
	,TO_CHAR(sysdate,'WW') as 週
	,TO_CHAR(sysdate,'YYYY/MM/DD HH24:MI:SS') as 日付文字列
	,MONTHS_BETWEEN(sysdate,'2005/01/01') as 期間月数
	,TO_CHAR(LAST_DAY(sysdate),'DD')  as 月の最終日
from dual