1Convert::NLS_DATE_FORMAUTs(e3rpmC)ontributed Perl DocumeCnotnavteirotn::NLS_DATE_FORMAT(3pm)
2
3
4
6 Convert::NLS_DATE_FORMAT - Convert Oracle NLS_DATE_FORMAT <-> strftime
7 Format Strings
8
10 use Convert::NLS_DATE_FORMAT qw(oracle2posix posix2oracle);
11 my $strptime = oracle2posix($NLS_DATE_FORMAT);
12 $NLS_DATE_FORMAT = posix2oracle($strftime);
13
15 Convert Oracle's NLS_DATE_FORMAT string into a strptime format string,
16 or the reverse.
17
18 Functions
19 oracle2posix
20 Takes an Oracle NLS_DATE_FORMAT string and converts it into
21 formatting string compatible with "strftime" or "strptime".
22
23 my $format = oracle2posix('YYYY-MM-DD HH24:MI:SS'); # '%Y-%m-%d %H:%M:%S'
24
25 Character sequences that should not be translated may be enclosed
26 within double quotes, as specified in the Oracle documentation.
27
28 my $format = oracle2posix('YYYY-MM-DD"T"HH24:MI:SS'); # '%Y-%m-%dT%H:%M:%S'
29
30 posix2oracle
31 Takes a "strftime" or "strptime" formatting string and converts it
32 into an Oracle NLS_DATE_FORMAT string. It is possible to create
33 strings which Oracle will not accept as valid NLS_DATE_FORMAT
34 strings.
35
36 my $format = posix2oracle('%Y-%m-%d %H:%M:%S'); # 'YYYY-MM-DD HH24:MI:SS'
37
38 EXPORT
39 None by default. "oracle2posix" and "posix2oracle" when asked.
40
42 DateTime::Format::Oracle.
43
45 Nathan Gray, <kolibrie@cpan.org>
46
48 Copyright (C) 2005, 2006, 2011, 2012, 2016 Nathan Gray
49
50 This library is free software; you can redistribute it and/or modify it
51 under the same terms as Perl itself, either Perl version 5.8.4 or, at
52 your option, any later version of Perl 5 you may have available.
53
54
55
56perl v5.28.1 2016-01-03 Convert::NLS_DATE_FORMAT(3pm)