title: to_Char(DATE) with time
body: <p>I have a DB (Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production). In there is a table (Course) in which I have a Date column (start_dte). I want to format the output to a char so I used:</p>
  
  <pre><code>SELECT start_dte,
     to_Char(start_dte) AS start_dte_2,
     to_Char(start_dte,'DD.MM.YYYY') AS start_dte_3,
     to_Char(start_dte,'DD.MM.YYYY HH24:MI:SS') AS start_dte_4,
     to_Char(start_dte,'DD.MM.YYYY HH12:MI:SS') AS start_dte_5,
     to_Char(start_dte,'DD.MM.YYYY HH.MI.SSXFF AM') AS start_dte_6,
     to_Char(start_dte,'DD.MM.YYYY HH24:MI:SSxFF') AS start_dte_7,
     to_Char(start_dte,'DD-MON-YYYY HH24:MI:SSxFF TZH:TZM') AS start_dte_8
  FROM Course
  </code></pre>
  
  <p>The Results:</p>
  
  <p><a href="https://i.stack.imgur.com/fnlnb.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fnlnb.png" alt="enter image description here"></a></p>
  
  <p>Number 6,7,8 give me </p>
  
  <blockquote>
    <p>java.sql.SQLException: ORA-01821: date format not recognized</p>
  </blockquote>
  
  <p>6 has the same format as: </p>
  
  <pre><code>SELECT value
    FROM V$NLS_PARAMETERS
   WHERE parameter = 'NLS_TIME_FORMAT' 
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/6PFr8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6PFr8.png" alt="enter image description here"></a></p>
  
  <p>7 and 8 are taken from the Oracle documentation but this is only for timestamps. So what i am missing? I know the actual datatype should be datetime but I only have read access to that DB. What i would actually like: </p>
  
  <p><a href="https://i.stack.imgur.com/JiTyP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JiTyP.png" alt="enter image description here"></a></p>
  
  <p>Or even better: </p>
  
  <p><a href="https://i.stack.imgur.com/n2tFi.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/n2tFi.png" alt="enter image description here"></a></p>