I want the month and day columns to give out such values: 01,02,03 and so on, but not just 1,2,3 and so on, how can I do this?

Question

PostgreSQL

Here is my request:

SELECT
  Extract(YEAR  from date::date ) AS year 
, Extract(MONTH  from date::date ) AS month 
, Extract(DAY from date::date ) AS day 
FROM sales;

Answer 1

You can add zeros with lpad .
Or instead of using extract, format the date using the to_char method .