編集履歴

回答編集履歴

誤字の修正

2017/08/21 03:58

投稿

スコア596

test CHANGED Viewed

@@ -1,6 +1,6 @@
 ```sql
-strftime('%Y', cast(postdate as timestamp), 'unixepoch', 'localtime')
+strftime('%Y', postdate, 'unixepoch', 'localtime')
 ```
@@ -8,7 +8,7 @@
 ```sql
-SELECT * FROM table1 WHERE strftime('%Y', cast(postdate as timestamp), 'unixepoch', 'localtime') = '2017';
+SELECT * FROM table1 WHERE strftime('%Y', postdate, 'unixepoch', 'localtime') = '2017';
 ```