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.