title: How to get year, month and day from seconds in PostgreSql?
body: <p>I'm trying to create three columns based on date in seconds format.</p>
  
  <p>My <code>user.updated_at = 1521533490</code></p>
  
  <p>I would like to get year, month and day separately and put these formatted values to columns for example:</p>
  
  <p>year -> 2018, month -> 11, day -> 23</p>
  
  <p>Does someone know how can I do that in <code>pgSQL</code>?</p>