HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Hours:
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Invalid NLS parameter used in sql...

 
Ratzie
Super Advisor

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;
1 REPLY
Ratzie
Super Advisor

Re: Invalid NLS parameter used in sql...

Sorry I get an error:
ORA-12702: invalid NLS parameter string used in SQL function