Sql Datetime

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

DateTime::Calendar::FrenchRevolutionary - dates in the French Revolutionary Calendar. SYNOPSIS use DateTime::Calendar::FrenchRevolutionary; $dt = DateTime::Calendar::FrenchRevolutionary->new( year => 8, month => 2, day => 18, ); # convert FrenchRevolutionary->Gregorian... $dtgreg =...

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

Dimedis::Sql is a SQL/DBI Interface for banking applications. SYNOPSIS use Dimedis::Sql; my $sqlh = new Dimedis::Sql ( ... ); $sqlh->install ( ... ); my $seq_id = $sqlh->insert ( ... ); my $modified = $sqlh->update ( ... ); my $blob_sref = $sqlh->blob_read ( ... ); $sqlh->use_db (...


Platforms: *nix

SQL::Shell is a command interpreter for DBI shells. SYNOPSIS use SQL::Shell; #Initialise and configure my $sqlsh = new SQL::Shell(%settings); $sqlsh->set($setting, $new_value); $value = $sqlsh->get($setting); #Interpret commands $sqlsh->execute_command($command);...


Platforms: *nix

Rose::DateTime::Util Perl module contains some simple DateTime wrapper functions. SYNOPSIS use Rose::DateTime::Util qw(:all); $now = parse_date(now); $then = parse_date(12/25/2001 11pm); print $now->day_of_week; # e.g., "Monday" # "December 25th 2001 at 11:00:00 PM" $date_text =...


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

DateTime::Calendar::Mayan is a Perl module with the Mayan Long Count, Haab, and Tzolkin calendars. SYNOPSIS use DateTime::Calendar::Mayan my $dtcm = DateTime::Calendar::Mayan->new( baktun => 12, katun => 19, tun => 10, uinal => 2, kin => 8, # alternate epoch epoch => DateTime->new(...


Platforms: *nix

DateTime::Event::Cron is a DateTime extension for generating recurrence sets from crontab lines and files. SYNOPSIS use DateTime::Event::Cron; # DateTime::Set construction from crontab line $crontab = */3 15 1-10 3,4,5 */2; $set = DateTime::Event::Cron->from_cron($crontab); $iter =...


Platforms: *nix

SQL::Generator is a Perl module to generate SQL-statements with oo-perl. SYNOPSIS use SQL::Generator; With this module you can easily (and very flexible) generate/construct sql-statements. As a rookie, you are used to write a lot of sprintf`s every time i needed a statement (i.e.for DBI)....


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::Amazon::Request::Help is an Interface to retrieve Help content. SYNOPSIS $dbh = DBI->connect(dbi:Amazon:, $amznid, undef, { amzn_mode => books, amzn_locale => us, amzn_max_pages => 3 }) or die "Cannot connect: " . $DBI::errstr; # # search for some Perl DBI books # $sth =...


Platforms: *nix

SQL::Amazon::UserGuide is a Perl module with user Guide for DBD/SQL::Amazon. SYNOPSIS # # create the parser, passing in the current Amazon metadata # my $parser = SQL::Amazon::Parser->new(%attrs); # # parse a SQL statement, returning a SQL::Amazon::Statement # my $stmt =...


Platforms: *nix

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


Platforms: *nix

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


Platforms: *nix

DateTime::Locale is a Perl module with localization support for DateTime.pm. SYNOPSIS use DateTime::Locale; my $loc = DateTime::Locale->load(en_GB); print $loc->native_locale_name, "n", $loc->long_datetime_format, "n"; # but mostly just things like ... my $dt = DateTime->now( locale...


Platforms: *nix

DateTime::Format::Strptime is a Perl module to parse and format strp and strf time patterns. SYNOPSIS use DateTime::Format::Strptime; my $Strp = new DateTime::Format::Strptime( pattern => %T, locale => en_AU, time_zone => Australia/Melbourne, ); my $dt =...


Platforms: *nix

sql++ is an easily configurable, feature-rich, portable command-line SQL tool. It can be used with many different databases and in place of other commandline tools such as MySQLs mysql-client, Microsoft SQL, PostgreSQLs psql, and Oracles sqlplus. sql++ project has features such as multiple...


Platforms: *nix

SQL Uniform is a database client with a graphical user interface (GUI). The project is a helper application to relational databases of various types regarding query, maintenance, data comparison, export (convert), and import. It supports any kind of database and database servers to which there...


Platforms: *nix

DateTime::Calendar::Hebrew is a Perl module with dates in the Hebrew calendar. SYNOPSIS use DateTime::Calendar::Hebrew; $dt = DateTime::Calendar::Hebrew->new( year => 5782, month => 10, day => 4 ); DateTime::Calendar::Hebrew is the implementation of the Hebrew calendar. Read on for more...


Platforms: *nix