Databases
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