Time::Piece::MSSQL - MSSQL-specific methods for Time::Piece
version 0.022
use Time::Piece::MSSQL; my $time = localtime; print $time->mssql_datetime; print $time->mssql_smalldatetime; my $time = Time::Piece->from_mssql_datetime( $mssql_datetime ); my $time = Time::Piece->from_mssql_smalldatetime( $mssql_smalldatetime );
This module adds functionality to Time::Piece, providing methods useful for using the object in conjunction with a Microsoft SQL database connection. It will produce and parse MSSQL's default-format datetime values.
These methods return the Time::Piece object, formatted in the default notation for the correct MSSQL datatype.
my $time = Time::Piece->from_mssql_datetime($timestring);
my $time = Time::Piece->from_mssql_smalldatetime($timestring);
These methods construct new Time::Piece objects from the given strings, which must be in the default MSSQL format for the correct datatype. If the string is empty, undefined, or unparseable, undef is returned.
undef
This module saves less time than Time::Piece::MySQL, because there are fewer strange quirks to account for, but it becomes useful when tied to autoinflation of datatypes in Class::DBI::MSSQL.
Ricardo SIGNES <rjbs@cpan.org>
This software is copyright (c) 2005 by Ricardo SIGNES.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
To install Time::Piece::MSSQL, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Time::Piece::MSSQL
CPAN shell
perl -MCPAN -e shell install Time::Piece::MSSQL
For more information on module installation, please visit the detailed CPAN module installation guide.