How to display the days of the week?

In postgresql you can use :

extract(dow from datefield) as day_of_week

That gets you the number between 0 and 6 (0=sunday). If that is what you need?