Free datetime format excel 0.2901 software for linux

DateTime::Format::Excel is a Perl module that can convert between DateTime and Excel dates.

SYNOPSIS

use DateTime::Format::Excel;

# From Excel via class method:

my $datetime = DateTime::Format::Excel->parse_datetime( 37680 );
print $datetime->ymd(.); # 2003.02.28

# or via an object

my $excel = DateTime::Format::Excel->new();
print $excel->parse_datetime( 25569 )->ymd; # 1970-01-01

# Back to Excel number:

use DateTime;
my $dt = DateTime->new( year => 1979, month => 7, day => 16 );
my $daynum = DateTime::Format::Excel->format_datetime( $dt );
print $daynum; # 29052

# or via an object
my $other_daynum = $excel->format_datetime( $dt );
print $other_daynum; # 29052

Excel uses a different system for its dates than most Unix programs. This module allows you to convert between a few of the Excel raw formats and DateTime objects, which can then be further converted via any of the other DateTime::Format::* modules, or just with DateTimes methods.

If you happen to be dealing with dates between 1 Jan 1900 and 1 Mar 1900 please read the notes on epochs.

If youre wanting to handle actual spreadsheet files, you may find Spreadsheet::WriteExcel and Spreadsheet::ParseExcel of use.

DateTime::Format::Pg is a Perl module to parse and format PostgreSQL dates and times.

SYNOPSIS

use DateTime::Format::Pg;

my $dt = DateTime::Format::Pg->parse_datetime( 2003-01-16 23:12:01 );

# 2003-01-16T23:12:01+0200
DateTime::Format::Pg->format_datetime($dt);

This module understands the formats used by PostgreSQL for its DATE, TIME, TIMESTAMP, and INTERVAL data types. It can be used to parse these formats in order to create DateTime or DateTime::Duration objects, and it can take a DateTime or DateTime::Duration object and produce a string representing it in a format accepted by PostgreSQL.

CONSTRUCTORS

The following methods can be used to create DateTime::Format::Pg objects.
new( name => value, ... )

Creates a new DateTime::Format::Pg instance. This is generally not required for simple operations. If you wish to use a different parsing style from the default then it is more comfortable to create an object.

my $parser = DateTime::Format::Pg->new()
my $copy = $parser->new( european => 1 );

This method accepts the following options:

european

If european is set to non-zero, dates are assumed to be in european dd/mm/yyyy format. The default is to assume US mm/dd/yyyy format (because this is the default for PostgreSQL).

This option only has an effect if PostgreSQL is set to output dates in the PostgreSQL (DATE only) and SQL (DATE and TIMESTAMP) styles.
Note that you dont have to set this option if the PostgreSQL server has been set to use the ISO format, which is the default.

server_tz

This option can be set to a DateTime::TimeZone object or a string that contains a time zone name.

This value must be set to the same value as the PostgreSQL servers time zone in order to parse TIMESTAMP WITH TIMEZONE values in the PostgreSQL, SQL, and German formats correctly.

Note that you dont have to set this option if the PostgreSQL server has been set to use the ISO format, which is the default.

clone()

This method is provided for those who prefer to explicitly clone via a method called clone().

my $clone = $original->clone();

If called as a class method it will die.

DateTime::Format::Epoch::Lilian is a Perl module to convert DateTimes to/from Lilian Days.

SYNOPSIS

use DateTime::Format::Epoch::Lilian;

my $dt = DateTime::Format::Epoch::Lilian->parse_datetime( 53244.5 );
# 2004-08-27T00:00:00

DateTime::Format::Epoch::Lilian->format_datetime($dt);
# 53244.5

my $formatter = DateTime::Format::Epoch::Lilian->new();
my $dt2 = $formatter->parse_datetime( 53244.5 );
# 2004-08-27T00:00:00
$formatter->format_datetime($dt2);
# 53244.5

This module can convert a DateTime object (or any object that can be converted to a DateTime object) to the Modified Julian Day number. See DateTime::Format::Epoch::JD for a description.

DateTime::Format::Epoch::RJD is a Perl module that can convert DateTimes to/from Reduced Julian Days.

SYNOPSIS

use DateTime::Format::Epoch::RJD;

my $dt = DateTime::Format::Epoch::RJD->parse_datetime( 53244.5 );
# 2004-08-27T00:00:00
DateTime::Format::Epoch::RJD->format_datetime($dt);
# 53244.5

my $formatter = DateTime::Format::Epoch::RJD->new();

my $dt2 = $formatter->parse_datetime( 53244.5 );
# 2004-08-27T00:00:00

$formatter->format_datetime($dt2);
# 53244.5

This module can convert a DateTime object (or any object that can be converted to a DateTime object) to the Reduced Julian Day number. See DateTime::Format::Epoch::JD for a description.

DateTime::Format::Epoch::DotNet is a Perl module that can convert DateTimes to/from .NET epoch seconds.

SYNOPSIS

use DateTime::Format::Epoch::DotNet;

my $dt = DateTime::Format::Epoch::DotNet->parse_datetime( 1051488000 );

DateTime::Format::Epoch::DotNet->format_datetime($dt);
# 1051488000

my $formatter = DateTime::Format::Epoch::DotNet->new();
my $dt2 = $formatter->parse_datetime( 1051488000 );
$formatter->format_datetime($dt2);

This module can convert a DateTime object (or any object that can be converted to a DateTime object) to the number of seconds since the epoch defined in the .NET Framework SDK.
Note that this epoch is defined in the local time zone. This means that these two pieces of code will print the same number of seconds, even though they represent two datetimes 6 hours apart:

$dt = DateTime->new( year => 2003, month => 5, day => 2,
time_zone => Europe/Amsterdam );
print $formatter->format_datetime($dt);

$dt = DateTime->new( year => 2003, month => 5, day => 2,
time_zone => America/Chicago );
print $formatter->format_datetime($dt);

DateTime::Format::Epoch::Unix is a Perl module that can convert DateTimes to/from Unix epoch seconds.

SYNOPSIS

use DateTime::Format::Epoch::Unix;

my $dt = DateTime::Format::Epoch::Unix->parse_datetime( 1051488000 );
# 2003-04-28T00:00:00

DateTime::Format::Epoch::Unix->format_datetime($dt);
# 1051488000

my $formatter = DateTime::Format::Epoch::Unix->new();
my $dt2 = $formatter->parse_datetime( 1051488000 );
$formatter->format_datetime($dt2);

This module can convert a DateTime object (or any object that can be converted to a DateTime object) to the number of seconds since the Unix epoch.

DateTime::Format::Epoch::TAI64 is a Perl module that can convert DateTimes to/from TAI64 values.

SYNOPSIS

use DateTime::Format::Epoch::TAI64;

my $dt = DateTime::Format::Epoch::TAI64
->parse_datetime( 4611686019483526367 );
# 2003-06-20T19:49:59

DateTime::Format::Epoch::TAI64->format_datetime($dt);
# 4611686019483526367

my $formatter = DateTime::Format::Epoch::TAI64->new();

$dt = $formatter->parse_datetime( 4611686019483526367 );
# 2003-06-20T19:49:59

$formatter->format_datetime($dt);
# 4611686019483526367

my $str_frmt = DateTime::Format::Epoch::TAI64->new(
format => string );

$dt = $str_frmt->parse_datetime( "x40 x3exf3x69x6a" );
# 2003-06-20T19:49:59

$str_frmt->format_datetime($dt);
# "x40 x3exf3x69x6a"

This module can convert a DateTime object (or any object that can be converted to a DateTime object) to a TAI64 value. The TAI64 timescale covers the entire expected lifespan of the universe (at least, if you expect the universe to be closed).

DateTime::Format::Builder is a Perl module to create datetime parser classes and objects.

SYNOPSIS

package DateTime::Format::Brief;
our $VERSION = 0.07;
use DateTime::Format::Builder
(
parsers => {
parse_datetime => [
{
regex => qr/^(d{4})(dd)(dd)(dd)(dd)(dd)$/,
params => [qw( year month day hour minute second )],
},
{
regex => qr/^(d{4})(dd)(dd)$/,
params => [qw( year month day )],
},
],
}
);

DateTime::Format::Builder creates DateTime parsers. Many string formats of dates and times are simple and just require a basic regular expression to extract the relevant information. Builder provides a simple way to do this without writing reams of structural code.

Builder provides a number of methods, most of which youll never need, or at least rarely need. Theyre provided more for exposing of the modules innards to any subclasses, or for when you need to do something slightly beyond what I expected.