-
-
06 Jan 2016 02:42:46 UTC
- Distribution: Convert-NLS_DATE_FORMAT
- Module version: 0.06
- Source (raw)
- Browse (raw)
- Changes
- How to Contribute
- Issues (1)
- Testers (2387 / 0 / 1)
- Kwalitee
Bus factor: 0- 95.16% Coverage
- License: perl_5
- Perl: v5.6.1
- Activity
24 month- Tools
- Download (11.06KB)
- MetaCPAN Explorer
- Permissions
- Subscribe to distribution
- Permalinks
- This version
- Latest version
- Dependencies
- none
- Reverse dependencies
- CPAN Testers List
- Dependency graph
NAME
Convert::NLS_DATE_FORMAT - Convert Oracle NLS_DATE_FORMAT <-> strftime Format Strings
SYNOPSIS
use Convert::NLS_DATE_FORMAT qw(oracle2posix posix2oracle); my $strptime = oracle2posix($NLS_DATE_FORMAT); $NLS_DATE_FORMAT = posix2oracle($strftime);
DESCRIPTION
Convert Oracle's NLS_DATE_FORMAT string into a strptime format string, or the reverse.
Functions
- oracle2posix
-
Takes an Oracle NLS_DATE_FORMAT string and converts it into formatting string compatible with
strftime
orstrptime
.my $format = oracle2posix('YYYY-MM-DD HH24:MI:SS'); # '%Y-%m-%d %H:%M:%S'
Character sequences that should not be translated may be enclosed within double quotes, as specified in the Oracle documentation.
my $format = oracle2posix('YYYY-MM-DD"T"HH24:MI:SS'); # '%Y-%m-%dT%H:%M:%S'
- posix2oracle
-
Takes a
strftime
orstrptime
formatting string and converts it into an Oracle NLS_DATE_FORMAT string. It is possible to create strings which Oracle will not accept as valid NLS_DATE_FORMAT strings.my $format = posix2oracle('%Y-%m-%d %H:%M:%S'); # 'YYYY-MM-DD HH24:MI:SS'
EXPORT
None by default.
oracle2posix
andposix2oracle
when asked.SEE ALSO
AUTHOR
Nathan Gray, <kolibrie@cpan.org>
COPYRIGHT AND LICENSE
Copyright (C) 2005, 2006, 2011, 2012, 2016 Nathan Gray
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.4 or, at your option, any later version of Perl 5 you may have available.
Module Install Instructions
To install Convert::NLS_DATE_FORMAT, copy and paste the appropriate command in to your terminal.
cpanm Convert::NLS_DATE_FORMAT
perl -MCPAN -e shell install Convert::NLS_DATE_FORMAT
For more information on module installation, please visit the detailed CPAN module installation guide.