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 diff
     1.1 --- a/s4-blog.sh	Wed Apr 24 12:27:59 2019 +0900
     1.2 +++ b/s4-blog.sh	Wed Apr 24 12:31:28 2019 +0900
     1.3 @@ -279,19 +279,23 @@
     1.4  	a.rowid,
     1.5  	s.TIME,
     1.6  	CASE WHEN s.TIME < '2019-05'
     1.7 -	     THEN printf('平成%d年%d月%d日',
     1.8 +	     THEN printf('平成%d年%d月%d日%s',
     1.9  			 substr(s.TIME, 1, 4)-1988,
    1.10  			 substr(s.TIME, 6, 2),
    1.11 -			 substr(s.TIME, 9, 2))
    1.12 +			 substr(s.TIME, 9, 2),
    1.13 +			 substr(s.TIME, 12)
    1.14 +			 )
    1.15               WHEN s.TIME < '2020'
    1.16  	     THEN printf('令和元年%d月%d日',
    1.17  			 substr(s.TIME, 6, 2),
    1.18 -			 substr(s.TIME, 9, 2))
    1.19 +			 substr(s.TIME, 9, 2),
    1.20 +			 substr(s.TIME, 12))
    1.21               WHEN s.TIME < '2050'
    1.22  	     THEN printf('令和%d年%d月%d日',
    1.23  			 substr(s.TIME, 1, 4)-2018,
    1.24  			 substr(s.TIME, 6, 2),
    1.25 -			 substr(s.TIME, 9, 2))
    1.26 +			 substr(s.TIME, 9, 2),
    1.27 +			 substr(s.TIME, 12))
    1.28               ELSE s.TIME
    1.29  	     END reki,
    1.30          CASE WHEN s.TIME > '$atime' THEN 'new' ELSE '' END newer,