Extract day of week from date field in PostgreSQL assuming weeks start on Monday : <pre><code>select extract(dow from datefield)
</code></pre>

<p>extract a number from 0 to 6, where 0 is Sunday; is there a way to get the day of the week in SQL assuming that weeks start on Monday (so 0 will be Monday)?</p>
