# HG changeset patch # User HIROSE Yuuji # Date 1556076688 -32400 # Node ID 95f2b54ea6d5a84e31eb28f4d828d40d942c5d9e # Parent 27442a1d95c010043262cb1dfeb0aa9e0947a6a2 Forgot to display time in Wareki diff -r 27442a1d95c0 -r 95f2b54ea6d5 s4-blog.sh --- 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,