title: Date Time Issue
body: <p>the data table (C#) returns date/time (with AM/PM) column with below data,</p>
  
  <p>08/01/2011 5:16:02 PM<br>
  07/27/2011 9:31:26 PM</p>
  
  <p>how to convert the same to string data type in C#?</p>
  
  <p>in SQL, i can convert datetime to string by below, but how to convert in C#....?</p>
  
  <pre><code>ISNULL(CASE WHEN CONVERT(CHAR(10),FirstCommunicationDate,108)&lt;'12:00:00'  THEN CONVERT(VARCHAR(11),FirstCommunicationDate,101)+ SUBSTRING(CONVERT(VARCHAR(20),FirstCommunicationDate,109),12,15) + ' AM'
              ELSE CONVERT(VARCHAR(11),FirstCommunicationDate,101)+ SUBSTRING(CONVERT(VARCHAR(20),FirstCommunicationDate,109),12,15) + ' PM' END, '') AS FirstCommunicationDate
  </code></pre>