Mercurial > hgrepos > hgweb.cgi > s4
changeset 572:95f2b54ea6d5
Forgot to display time in Wareki
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Wed, 24 Apr 2019 12:31:28 +0900 |
parents | 27442a1d95c0 |
children | 9a4504aef7ac |
files | s4-blog.sh |
diffstat | 1 files changed, 8 insertions(+), 4 deletions(-) [+] |
line wrap: on
line diff
--- a/s4-blog.sh Wed Apr 24 12:27:59 2019 +0900 +++ b/s4-blog.sh Wed Apr 24 12:31:28 2019 +0900 @@ -279,19 +279,23 @@ a.rowid, s.TIME, CASE WHEN s.TIME < '2019-05' - THEN printf('平成%d年%d月%d日', + THEN printf('平成%d年%d月%d日%s', substr(s.TIME, 1, 4)-1988, substr(s.TIME, 6, 2), - substr(s.TIME, 9, 2)) + substr(s.TIME, 9, 2), + substr(s.TIME, 12) + ) WHEN s.TIME < '2020' THEN printf('令和元年%d月%d日', substr(s.TIME, 6, 2), - substr(s.TIME, 9, 2)) + substr(s.TIME, 9, 2), + substr(s.TIME, 12)) WHEN s.TIME < '2050' THEN printf('令和%d年%d月%d日', substr(s.TIME, 1, 4)-2018, substr(s.TIME, 6, 2), - substr(s.TIME, 9, 2)) + substr(s.TIME, 9, 2), + substr(s.TIME, 12)) ELSE s.TIME END reki, CASE WHEN s.TIME > '$atime' THEN 'new' ELSE '' END newer,