1. Sekolah Dasar
  2. Sekolah Menengah Pertama
  3. Sekolah Menengah Atas
  4. Mata Pelajaran
  5. Programming

Postgresql Where Datetrunc Month And Year Equal

[Solved] Postgresql Where Datetrunc Month And Year Equal | Sql - Code Explorer | yomemimo.com
Question : postgresql where datetrunc month and year equal

Answered by : augusto-vicente

... WHERE date_trunc('month', b.col) = date_trunc('month', a.col);

Source : https://stackoverflow.com/questions/4531577/how-to-extract-year-and-month-from-date-in-postgresql-without-using-to-char-fu | Last Update : Mon, 01 Feb 21

Answers related to postgresql where datetrunc month and year equal

Code Explorer Popular Question For Sql