1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
|
# 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` or `strptime`.
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` or `strptime` 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` and `posix2oracle` when asked.
# SEE ALSO
[DateTime::Format::Oracle](https://metacpan.org/pod/DateTime::Format::Oracle).
# 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.
|
