title: how to get day of week from date in apache drill sql?
body: <p>I am using dbeaver connected to apache drill sql , trying to get day of week. </p>
  
  <p>For example for <code>'1/27/2019'</code> the day of week is <code>1</code>, considering sunday as the first day of week. </p>
  
  <p>Example 2 : <code>'1/28/2019'</code>, output : <code>2</code></p>