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