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    1419702037(Sun, 28 Dec 2014 02:40:37 +0900)

OPTIONS

-f   --format       date format // '%a, %d %b %Y %H:%M:%S %z'

--start-bracket     change start bracket // '('
--end-bracket       change end bracket   // ')'

--re                additional column condition
--no-re             no replace condition(this option has overriding priority)
--min-time          no replace if the value is smaller than this option
--replace           not to add the date to unixtime but to be replaced it

EXAMPLES

To edit the date format.

$ cat sql_result | from_unixtime --format '%Y/%m/%d %H:%M:%S'
id    1
value         1419702037
created_at    1419702037(2014/12/28 02:40:37)
updated_at    1419702037(2014/12/28 02:40:37)

Also replace value line with '--re' option.

$ cat sql_result | from_unixtime --re value
id    1
value         1419702037(Sun, 28 Dec 2014 02:40:37 +0900)
created_at    1419702037(Sun, 28 Dec 2014 02:40:37 +0900)
updated_at    1419702037(Sun, 28 Dec 2014 02:40:37 +0900)

If you do not want to replace then you use '--no-re' option

$ cat sql_result | from_unixtime --no-re updated
id    1
value         1419702037
created_at    1419702037(Sun, 28 Dec 2014 02:40:37 +0900)
updated_at    1419702037

CONFIGURATION

`from_unixtime` command will look for a configuration file before reading its command line parameters. This function depends on Config::CmdRC.

The configuration file is `.from_unixtimerc`. And the location of a configuration file is /etc or $HOME but if the CMDRC_DIR environment variable is set, `from_unixtime` will look for configuration file in that directory or current directory.

A sample configuration file might read:

format: %Y/%m/%d %H:%M:%S
start-bracket: ' ('

AUTHOR

Dai Okabayashi <bayashi@cpan.org>

SEE ALSO

App::FromUnixtime, Config::CmdRC

LICENSE

This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See perlartistic.