#!/usr/local/bin/perl

use strict;
use warnings;

use Time::Piece::MySQL;
use Time::Seconds;
use Data::Dumper;

my $time = localtime;
my $future_time = $time + ONE_HOUR;

my $diff = $future_time - $time;

print "Local time:  " . $time . "\n";
print "Future time: " . $future_time . "\n";
print "Difference:  " . $diff->hours . "hours \n";

print Dumper( $time, $future_time, $diff);

my $test_time = Time::Piece->from_mysql_datetime( '2004-03-05 20:30:00' );
print Dumper $test_time;
print "Test time: " . $test_time . "\n";
$diff = $test_time - $time;
print $diff->minutes . " minutes\n";

$test_time = Time::Piece->strptime( '2004-03-05 20:30:00', '%Y-%m-%d %H:%M:%S' );
print Dumper $test_time;
print "Test time: " . $test_time . "\n";
$diff = $test_time - $time;
print $diff->minutes . " minutes\n";