如何在Perl中操作Sybase日期时间字符串？

cpan install DBI
cpan install DBD-Sybase

use DBI;

my $dsn = "dbi:Sybase:server=your_server;database=your_database";
my $username = "your_username";
my $password = "your_password";

my $dbh = DBI->connect($dsn, $username, $password)
    or die "Error connecting to Sybase: $DBI::errstr";

my $sth = $dbh->prepare("SELECT your_datetime_column FROM your_table");
$sth->execute();

while (my @row = $sth->fetchrow_array()) {
    my $datetime_string = $row[0];
    print "DateTime string: $datetime_string\n";
}

use Time::Piece;

my $datetime_string = "2022-01-01 12:34:56";
my $time = Time::Piece->strptime($datetime_string, "%Y-%m-%d %H:%M:%S");

print "Year: ", $time->year, "\n";
print "Month: ", $time->month, "\n";
print "Day: ", $time->day, "\n";
print "Hour: ", $time->hour, "\n";
print "Minute: ", $time->minute, "\n";
print "Second: ", $time->second, "\n";

use Time::Seconds;

my $time = Time::Piece->new;
my $one_hour_later = $time + ONE_HOUR;
my $one_day_later = $time + ONE_DAY;
my $one_week_later = $time + 7 * ONE_DAY;

print "One hour later: ", $one_hour_later->strftime("%Y-%m-%d %H:%M:%S"), "\n";
print "One day later: ", $one_day_later->strftime("%Y-%m-%d %H:%M:%S"), "\n";
print "One week later: ", $one_week_later->strftime("%Y-%m-%d %H:%M:%S"), "\n";

use Time::Local;

my $year = 2022;
my $month = 1;
my $day = 1;
my $hour = 12;
my $minute = 34;
my $second = 56;

my $time = timelocal($second, $minute, $hour, $day, $month - 1, $year);

print "DateTime object: ", $time, "\n";

use Time::Piece;
use Time::Seconds;

my $datetime1 = Time::Piece->strptime("2022-01-01 12:34:56", "%Y-%m-%d %H:%M:%S");
my $datetime2 = Time::Piece->strptime("2022-01-02 12:34:56", "%Y-%m-%d %H:%M:%S");

if ($datetime1 < $datetime2) {
    print "Datetime1 is earlier than datetime2\n";
} elsif ($datetime1 > $datetime2) {
    print "Datetime1 is later than datetime2\n";
} else {
    print "Datetime1 is the same as datetime2\n";
}

my $interval = $datetime2 - $datetime1;
my $days = $interval / ONE_DAY;
my $hours = ($interval % ONE_DAY) / ONE_HOUR;
my $minutes = ($interval % ONE_HOUR) / ONE_MINUTE;
my $seconds = ($interval % ONE_MINUTE);

print "Interval: $days days, $hours hours, $minutes minutes, $seconds seconds\n";