Re: [SQL] parts of date_part()

played with some other things, like 'month' and 'year'. However, I was
wondering if there was a way to obtain the name of the day (Tuesday,
Wednesday, etc.) using this function, among other things. I tried

Try

select date_part ('dow', field_name) from table ;

This gives numbers 0-6 => Sunday-Saturday (I think). I suppose that
could be joined with another table with names.

Is there a more direct way to get the names?

Cheers,
Brook