> For the complete documentation index, see [llms.txt](https://ploegert.gitbook.io/til/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/datetime-operations/day-of-week-by-name-for-a-date.md).

# Day Of Week By Name For A Date

In [Day Of Week For A Date](/til/programmy/linux/is-app-installed/datetime-operations/day-of-week-for-a-date.md), I explained how to determine what day of the week a date is as an integer with PostgreSQL. This used the `date_part()` function. By using the `to_char()` function with a date or timestamp, we can determine the day of the week by name (e.g. Monday). For instance, to determine what day today is, try a statement like the following:

```sql
> select to_char(now(), 'Day');
  to_char
-----------
 Sunday
```

The `Day` part of the second argument is just one of many template patterns that can be used for formatting dates and times.

See [Data Type Formatting Functions](http://www.postgresql.org/docs/current/static/functions-formatting.html) in the Postgres docs for more details.