HPE Community
Operating System - HP-UX
1753774 Members
6917 Online
108799 Solutions
New Discussion

Invalid NLS parameter used in sql...

 
Ratzie
Super Advisor

‎04-17-2009 01:07 PM

‎04-17-2009 01:07 PM

Invalid NLS parameter used in sql...

This is a date field and would like to pull it back in CDT time.

Database is in UTC.
select to_char(ord_order.expires, 'GMT', 'CDT') from ord_order;
0 Kudos
Reply
1 REPLY 1
Ratzie
Super Advisor

‎04-17-2009 01:08 PM

‎04-17-2009 01:08 PM

Re: Invalid NLS parameter used in sql...

Sorry I get an error:
ORA-12702: invalid NLS parameter string used in SQL function
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.