Sql Datetime

SQL::Preproc is a Perl module to embed SQL in your Perl (ala SQL preprocessors). SYNOPSIS use SQL::Preproc subclass => Chart, emit => 1, keepsql => 1, syntax => [ Teradata ], pponly => 1, relax => 1, alias => 1, debug => 1; use DBI; use DBI qw(:sql_types); use...

DateTime::Format::Epoch::TJD is a Perl module that can convert DateTimes to/from Truncated Julian Days. SYNOPSIS use DateTime::Format::Epoch::TJD; my $dt = DateTime::Format::Epoch::TJD->parse_datetime( 13244.5 ); # 2004-08-27T00:00:00 DateTime::Format::Epoch::TJD->format_datetime($dt);...

DateTime::Format::Epoch is a Perl module that can convert DateTimes to/from epoch seconds. SYNOPSIS use DateTime::Format::Epoch; my $dt = DateTime->new( year => 1970, month => 1, day => 1 ); my $formatter = DateTime::Format::Epoch->new( epoch => $dt, unit => seconds, type => int, # or...


Platforms: *nix

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); #...


Platforms: *nix

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...


Platforms: *nix

DateTime::Format::Epoch::MacOS is a Perl module that can convert DateTimes to/from Mac OS epoch seconds. SYNOPSIS use DateTime::Format::Epoch::MacOS; my $dt = DateTime::Format::Epoch::MacOS->parse_datetime( 1051488000 ); DateTime::Format::Epoch::MacOS->format_datetime($dt); # 1051488000...


Platforms: *nix

DateTime::Calendar::Pataphysical is a Perl module with dates in the pataphysical calendar. SYNOPSIS use DateTime::Calendar::Pataphysical; $dt = DateTime::Calendar::Pataphysical->new( year => 1752, month => 10, day => 4 ); DateTime::Calendar::Pataphysical is the implementation of the...


Platforms: *nix

DateTime::Format::Roman is a Perl module with roman day numbering for DateTime objects. SYNOPSIS use DateTime::Format::Roman; my $formatter = DateTime::Format::Roman->new( pattern => %d %f %b %y ); my $dt = DateTime->new( year => 2003, month => 5, day => 28 );...


Platforms: *nix

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); #...


Platforms: *nix

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); #...


Platforms: *nix

DateTime::Format::Epoch::RataDie is a Perl module that can convert DateTimes to/from Rata Die. SYNOPSIS use DateTime::Format::Epoch::RataDie; my $dt = DateTime::Format::Epoch::RataDie->parse_datetime( $count ); DateTime::Format::Epoch::RataDie->format_datetime($dt); # $count my...


Platforms: *nix

DateTime::Format::Epoch::JD is Perl module Convert DateTimes to/from Julian Days. SYNOPSIS use DateTime::Format::Epoch::JD; my $dt = DateTime::Format::Epoch::JD->parse_datetime( 2453244.5 ); # 2004-08-27T00:00:00 DateTime::Format::Epoch::JD->format_datetime($dt); # 2453244.5 my...


Platforms: *nix

DateTime::Format::Epoch::MJD is a Perl module that can convert DateTimes to/from Modified Julian Days. SYNOPSIS use DateTime::Format::Epoch::MJD; my $dt = DateTime::Format::Epoch::MJD->parse_datetime( 53244 ); # 2004-08-27T00:00:00 DateTime::Format::Epoch::MJD->format_datetime($dt); #...


Platforms: *nix

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...


Platforms: *nix

SQL Admin is a Java client application to connect and send queries to different databases through JDBC. SQLAdmin uses the brand new SWT Toolkit. The main idea is to create a multiplatform and multidatabase thin client. For example, you can connect to an Microsoft SQL Server from a Linux...


Platforms: *nix

SQL::Translator::Manual is a Perl module that contains a manual for SQL translator. SYNOPSIS SQL::Translator (AKA "SQLFairy") is a collection of modules for transforming (mainly) SQL DDL files into a variety of other formats, including other SQL dialects, documentation, images, and code. In...


Platforms: *nix

SQL::Translator::Producer::GraphViz is a GraphViz producer for SQL::Translator. SYNOPSIS use SQL::Translator; my $trans = new SQL::Translator( from => MySQL, # or your db of choice to => GraphViz, producer_args => { out_file => schema.png, add_color => 1, show_constraints => 1,...


Platforms: *nix

Oracle::SQL is a Perl extension for building SQL statements. SYNOPSIS use Oracle::SQL; No automatically exported routines. You have to specifically to import the methods into your package. use Oracle::SQL qw(:sql); use Oracle::SQL /:sql/; use Oracle::SQL :sql; This is a package...


Platforms: *nix

Lingua::ZH::DateTime is a Perl module to convert time to chinese format. SYNOPSIS This module can convert asctime to chinese format in your locale. you can select china singapore hongkong taiwan locale and gb2312/big5 charset. asctime is ASC C standard format will from localtime like this:...


Platforms: *nix

DateTime::Format::Builder::Tutorial is a quick class on using Builder. CREATING A CLASS As most people who are writing modules know, you start a package with a package declaration and some indication of module version: package DateTime::Format::ICal; our $VERSION = 0.04; After that, you...


Platforms: *nix