NAME from_unixtime - to convert from unixtime to date suitably SYNOPSIS replace unixtime args $ from_unixtime 1419702037 1419702037(Sun, 28 Dec 2014 02:40:37 +0900) or filter unixtime suitably $ cat sql_result id 1 value 1419702037 created_at 1419702037 updated_at 1419702037 $ cat sql_result | from_unixtime id 1 value 1419702037 created_at 1419702037(Sun, 28 Dec 2014 02:40:37 +0900) updated_at 141