dow

The method dow() is a routine that provides a portable Day-Of-Week number from 0 to 6, starting on a Sunday. Normal day of week functions use varying start days, and offset numbers. For more information on the subject, see sqlDate().

The start day and numbering matches the PHP Date function.

The date/time fieldname to be processed

$sql = "SELECT {$db->dow('birth_date')}
          FROM employees
          WHERE emp_no = 10
$dayOfWeek = $db->getOne($sql);