1. Home
  2. SQL

Postgres month number

Code examples

3
0

postgresql today - 1 year 

select now() - INTERVAL '1 YEAR';

Similar pages

Similar pages with examples

In other languages

This page is in other languages

Русский
..................................................................................................................
Ссылка
Italiano
..................................................................................................................
Link
Polski
..................................................................................................................
Link
Română
..................................................................................................................
Legătură
한국어
..................................................................................................................
링크
हिन्दी
..................................................................................................................
लिंक
Français
..................................................................................................................
Lien
Türk
..................................................................................................................
Atıf
Česk
..................................................................................................................
Odka
Português
..................................................................................................................
Referênci
ไทย
..................................................................................................................
เชื่อมโยง
中文
..................................................................................................................
链接
Español
..................................................................................................................
Referencia
Slovenský
..................................................................................................................
Odkaz
Балгарскі
..................................................................................................................
Спасылка
Íslensk
..................................................................................................................
Link

Popular in the category

Popular pages with examples in the category

how to add 1 day in mysql query
how add 2 days in mysql date
mysql query add days in myslq
mysql add date sum
mysql add year to date
date add minutes mysql
sum days now mysql
how to add 10 days into date in mysql
adding number of days to a date in mysql
insert date my sql
mysql get last insert by datetime
one request to insert and select date in mysql
sql date time functions
date functions in sql
is time a keyword in sql
time mssql