title: how to select all with to_char function in sql statement
body: <p>the code below is my sqlcommand for select statement. Inside have a lots of data including two date data inside.</p>
  
  <pre><code>string sql = "SELECT * FROM TASKMASTER WHERE TASKNAME ='" + TaskName + "'";
  </code></pre>
  
  <p>can I add in <code>('DD-MM-YYYY HH24:MI:SS')AS CREATEDATE</code> into the sqlcommand and at the same time will call out all the column in the table?</p>