1Convert::NLS_DATE_FORMAUTs(e3r)Contributed Perl DocumentCaotnivoenrt::NLS_DATE_FORMAT(3)
2
3
4

NAME

6       Convert::NLS_DATE_FORMAT - Convert Oracle NLS_DATE_FORMAT <-> strftime
7       Format Strings
8

SYNOPSIS

10         use Convert::NLS_DATE_FORMAT qw(oracle2posix posix2oracle);
11         my $strptime = oracle2posix($NLS_DATE_FORMAT);
12         $NLS_DATE_FORMAT = posix2oracle($strftime);
13

DESCRIPTION

15       Convert Oracle's NLS_DATE_FORMAT string into a strptime format string,
16       or the reverse.
17
18       Functions
19
20       oracle2posix
21           Takes an Oracle NLS_DATE_FORMAT string and converts it into format‐
22           ting string compatible with "strftime" or "strptime".
23
24             my $format = oracle2posix('YYYY-MM-DD HH24:MI:SS'); # '%Y-%m-%d %H:%M:%S'
25
26       posix2oracle
27           Takes a "strftime" or "strptime" formatting string and converts it
28           into an Oracle NLS_DATE_FORMAT string. It is possible to create
29           strings which Oracle will not accept as valid NLS_DATE_FORMAT
30           strings.
31
32             my $format = posix2oracle('%Y-%m-%d %H:%M:%S'); # 'YYYY-MM-DD HH24:MI:SS'
33
34       EXPORT
35
36       None by default. "oracle2posix" and "posix2oracle" when asked.
37

SEE ALSO

39       DateTime::Format::Oracle.
40

AUTHOR

42       Nathan Gray, <kolibrie@cpan.org>
43

45       Copyright (C) 2005, 2006 Nathan Gray
46
47       This library is free software; you can redistribute it and/or modify it
48       under the same terms as Perl itself, either Perl version 5.8.4 or, at
49       your option, any later version of Perl 5 you may have available.
50
51
52
53perl v5.8.8                       2006-11-03       Convert::NLS_DATE_FORMAT(3)
Impressum