title: Which NLS_DATE_FORMAT would be picked by the Stored Procedure
body: <p>The NLS_date_format for database and session are as follows.</p>
  <pre><code>select * from nls_session_parameters : 
  =========================
   DD-MON-YYYY
  
  select * from nls_database_parameters: 
  =============
  DD-MON-RR
  </code></pre>
  <p>When my PLSQL procedure is called, which NLS_DATE_FORMAT would be picked? Will it be based on the current session date format or the database specified format.</p>
  <p>Thank you taking time to make me understand the topic</p>