The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

NAME

Win32::SqlServer::DTS::DateTime - DateTime Perl object built from Win32::OLE Variant values

SYNOPSIS

    use Win32::SqlServer::DTS::DateTime;
        use Win32::OLE::Variant;

        my $variant = Variant( VT_DATE, "April 1 99" );

        my $date = Win32::SqlServer::DTS::DateTime->new($variant);

DESCRIPTION

Extends the DateTime class constructor (new method) to create a DateTime object that is equal to a Win32::OLE::Variant object.

Some classes in DTS distribution have methods that returns date/time values, but as Variants. Win32::SqlServer::DTS::DateTime objects are used as substitutes.

Most attributes returned as date/time variants from DTS API original classes are read-only, so beware that changing a Win32::SqlServer::DTS::DateTime object attribute because, as long as it seems to work, it will not save the state in the DTS package: the Win32::SqlServer::DTS::DateTime is "disconnected" from the original date/time variant.

EXPORT

Nothing.

METHODS

new

Expects a Win32::OLE::Variant date object as a parameter.

SEE ALSO

  • MSDN on Microsoft website and MS SQL Server 2000 Books Online are a reference about using DTS' object hierarchy, but you will need to convert examples written in VBScript to Perl code.

  • DateTime.

  • Win32::OLE::Variant.

AUTHOR

Alceu Rodrigues de Freitas Junior, <arfreitas@cpan.org>

COPYRIGHT AND LICENSE

Copyright (C) 2008 by Alceu Rodrigues de Freitas Junior

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.8 or, at your option, any later version of Perl 5 you may have available.