select
Date() as 日付部分
,Time() as 時間部分
,Now() as 日付と時間1
,Now as 日付と時間2
,Year('2010/01/21 1:02:03') as 年1
,Month('2010/01/21 1:02:03') as 月1
,Day('2010/01/21 1:02:03') as 日1
,Hour('2010/01/21 1:02:03') as 時1
,Minute('2010/01/21 1:02:03') as 分1
,Second('2010/01/21 1:02:03') as 秒1
,Now() + 1 as 日数加算1
,DateAdd('d', 1, Now()) as 日数加算2
,DateAdd('m', -1, Now()) as 月数加算
,DateAdd('yyyy', 1, Now()) as 年数加算
,DateAdd('ww', -1, Now()) as 週数加算
,DateDiff('d', '2005/01/01', Now()) as 経過日数
,DatePart('yyyy', Now()) as 年2
,DatePart('m', Now()) as 月2
,DatePart('d', Now()) as 日2
,DatePart('h', Now()) as 時2
,DatePart('n', Now()) as 分2
,DatePart('s', Now()) as 秒2
,DatePart('w', Now()) as 曜日
,DatePart('ww', Now()) as 週
,DatePart('y', Now()) as 年間通算日
,DateValue('H1/01/01') as 平成
,DateValue('S1/01/01') as 昭和
,DateValue('T1/01/01') as 大正
,DateValue('M1/01/01') as 明治
,Format('2005/01/01', 'yyyy/MM/dd') as 日付文字列1
,Format('2005/01/01', 'yyyy/M/d') 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 日付
1
2
3
4
5
6
7
8
日数加算1
日数加算2
月数加算
年数加算
経過日数
日
年間通算日
年間通算日
2009-03-14 16:18:34
2009-03-14 16:18:34
2009-02-13 16:18:34
2010-03-13
1532
13
072
72
時
分
秒
月
曜日
週
年
日付
16
18
34
03
5
10
2009
2009-03-13
PostgreSQL
環境変数 TZ=JST-9
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
1
2
3
4
5
6
now
time
日数加算
日数加算
年数加算
経過日数
2009-03-13 16:31:50.503238+09
16:31:50.503238
2009-03-14 16:31:50.503238+09
2009-02-13 16:31:50.503238+09
2010-03-13 16:31:50.503238+09
1532
日
年間通算日
時
分
秒
milli秒
13
72
16
31
50.503238
50503.238
月
曜日
週
年
日付文字列1
日付文字列2
3
5
11
2009
2009/03/13 16:31:50
2009/3/13 16:31:50
Oracle
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