title: Extract time and day of the week from given datetime in sql
body: <p>I tried the <code>CONVERT(TIME,sample_datetime)</code>, but my software does not recognize TIME as a type.</p>
  
  <p>How do I take sample <code>datetime</code> and extract the time from it in one variable and the day of the week from it in another variable?</p>