NAME

Class::DBI::Plugin::DateFormat::Oracle - Extension to Class::DBI for Oracle date fields.

VERSION

This documentation refers to Class::DBI::Plugin::DateFormat::Oracle version 0.01

SYNOPSIS

package YourBase::CDBI;
use base 'Class::DBI';
__PACKAGE__->connection('dbi:Oracle:sid', user, pwd);
__PACKAGE__->set_nls_date_format('YY/MM/DD HH24:MI:SS');
$format = __PACKAGE__->get_nls_date_format;

DESCRIPTION

This module is Extension to Class::DBI for Oracle date fields.

METHOD

set_nls_date_format

__PACKAGE__->set_nls_date_format('YY/MM/DD HH24:MI:SS');

This method sets Oracle date field's format. This method execute "ALTER SESSION".

get_nls_date_format

$format = __PACKAGE__->get_nls_date_format;

This method gets Oracle date field's format.

DEPENDENCIES

Class::DBI

Carp

SEE ALSO

Class::DBI

Carp

Class::DBI's Cookbook

http://cdbi.dcmanaged.com/wiki/Working_With_Oracle_Date_Fields

Refer to the Oracle documentation for valid date formats.

BUGS AND LIMITATIONS

There are no known bugs in this module. Please report problems to Atsushi Kobayashi (<nekokak@cpan.org>) Patches are welcome.

AUTHOR

Atsushi Kobayashi, <nekokak@cpan.org>

COPYRIGHT AND LICENSE

Copyright (C) 2005 by Atsushi Kobayashi (<nekokak@cpan.org>). All rights reserved.

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See perlartistic.

cpanm Class::DBI::Plugin::DateFormat::Oracle

perl -MCPAN -e shell
install Class::DBI::Plugin::DateFormat::Oracle