pierdom/get_day_name.sql

Last active September 6, 2017 08:08

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/pierdom/6a2e439dcec6855568db7ccd09708e47.js"></script>
Save pierdom/6a2e439dcec6855568db7ccd09708e47 to your computer and use it in GitHub Desktop.

Download ZIP

[Postgres: from date to weekday] Get week of the day from a date column in Postgres (full name: monday, tuesday, ...) #postgresql #sql

Raw

get_day_name.sql

	select to_char(<mydate>, 'day')
	from mytable

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment