---
name: "Convert::NLS_DATE_FORMAT"
section: "3pm"
platform: "linux"
package: "libconvert-nls-date-format-perl"
version: "0.06-3"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/Convert::NLS_DATE_FORMAT"
---

# Convert::NLS\_DATE\_FORMAT(3pm)

Convert Oracle NLS\_DATE\_FORMAT \<-\> strftime Format Strings

## 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.

## 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.