- Notifications
You must be signed in to change notification settings - Fork 1.3k
/
Copy path_1853.sql
7 lines (7 loc) · 455 Bytes
/
_1853.sql
1
2
3
4
5
6
7
-- Write your PostgreSQL query statement below
-- 1. use to_char function
-- 2. use FM to strip padding space, FM is a data type formatting function in PostgreSQL that removes leading zeros and trailing spaces that would otherwise be added to make a pattern's output fixed-width
-- 3. Day gives you the day in the week
-- 4. DD gives you the day in the month
-- 5. YYYY gives you the year
select to_char(day, 'FMDay, FMMonth FMDD, YYYY') as day from Days;