# Date puzzle for starters

DevFeed: [Date puzzle for starters](<https://devfeed.tech/articles/date-puzzle-for-starters-34395.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2010/10/date-puzzle-for-starters/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2010-10-08T08:00:00Z

Content type: article

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [function](<https://devfeed.tech/topics/function.md>), [IRC](<https://devfeed.tech/topics/irc.md>)

Tags: [blog](<https://devfeed.tech/tags/blog.md>), [exercise](<https://devfeed.tech/tags/exercise.md>), [function](<https://devfeed.tech/tags/function.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [puzzle](<https://devfeed.tech/tags/puzzle.md>)

## AI overview

A PostgreSQL date puzzle explores how to identify the nth occurrence of a specified weekday within a month. The article discusses an unfinished function and leaves improvements--such as supporting multiple nth weekdays--as an exercise for readers.

## Source excerpt

The PostgreSQL IRC channel is a good place to be, for all the very good help you can get there, because people are always wanting to remain helpful, because of the off-topics discussions sometime, or to get to talk with community core members. And to start up your day too. This morning's question started simple : "how can I check if today is the "first sunday fo the month". or "the second tuesday of the month" etc?"