Sql Datetime

Data::Faker::DateTime is a Data::Faker plugin. DATA PROVIDERS unixtime Return a unix time (seconds since the epoch) for a random time between the epoch and now. date Return a random date as a string, using a random date format (see date_format). time Return a random time as a...

DateTime::Event::Sunrise is a Perl DateTime extension for computing the sunrise/sunset on a given day. SYNOPSIS use DateTime; use DateTime::Event::Sunrise; my $dt = DateTime->new( year => 2000, month => 6, day => 20, ); my $sunrise = DateTime::Event::Sunrise ->sunrise ( longitude...

PKLite is a Lightweight SQL querying tool written in Java. Connects to any JDBC compliant database and will run on any OS with a Java VM. Features: keyword highlighting, result formatting, statement history, multi-window, multiple databases connects at one time.


Platforms: Windows, *nix

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


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::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::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::TimeZone::SystemV is a Perl module with System V and POSIX timezone strings. SYNOPSIS use DateTime::TimeZone::SystemV; $tz = DateTime::TimeZone::SystemV->new("EST5EDT"); if($tz->is_floating) { ... if($tz->is_utc) { ... if($tz->is_olson) { ... $category = $tz->category;...


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

EMS SQL Manager for PostgreSQL is a powerful tool for PostgreSQL Database Server administration and development. PostgreSQL Manager works with any PostgreSQL versions up to 8.2 and supports all of the latest PostgreSQL features including tablespaces, argument names in functions, and so on. It...


Platforms: Windows

Xfce 4 Datetime Plugin shows the date and time in the panel, and a calendar appears when you left-click on it. You can also have a look at ‘orage’, which is a bit more advanced calender. Usage: - Compile and install the datetime package - Right-click the Xfce panel > Add New Item >...


Platforms: *nix

SQL::Abstract::Limit is a portable LIMIT emulation. SYNOPSIS use SQL::Abstract::Limit; my $sql = SQL::Abstract::Limit->new( limit_dialect => LimitOffset );; # or autodetect from a DBI $dbh: my $sql = SQL::Abstract::Limit->new( limit_dialect => $dbh ); # or from a Class::DBI class: my...


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

SQL::Statement::Embed can embed a SQL engine in a DBD or module. SQL::Statement is designed to be easy to embed in other modules and to be especially easy to embed in DBI drivers. It provides a SQL Engine and the other module needs to then provide a data source and a storage mechanism. For...


Platforms: *nix

Rose::DateTime is a Perl module with DateTime helper functions and objects. SYNOPSIS use Rose::DateTime::Util qw(:all); $now = parse_date(now); $then = parse_date(12/25/2001 6pm); $date_text = format_date($then, "%D at %T %p"); ... use Rose::DateTime::Parser; $parser =...


Platforms: *nix

DL/SQL is declarative, turing-complete programming language based on top of SQL database. The main idea is to store both program and data in one SQL table and make all the computations in it. The current version of interpreter written in PHP contains quasi-lazy evaluation and simple caching....


Platforms: *nix

SQL::Schema is a Perl module to convert a data dictionary into SQL statements. SYNOPSIS use DBI; my $dbh = DBI->connect(...); use SQL::Schema; my $schema = SQL::Schema->new($dbh); my $sql = $schema->string; print $sql; print "$schema"; WARNING This is alpha software. It...


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

App::datetime is a date and time considerations. Most Enterprise development includes processing of dates and times. There are many date and time modules on CPAN, and choosing the right one can be confusing. There are no special perl data types for dates and times, so some direction is needed....


Platforms: *nix