Postgressql Veri Tabanında Date-time Fonksiyonları
Age, clock_timestamp, current_date, current_time, current_timestamp, date_part, extract, justify_days, justify_hours, localtime, localtimestamp, now, timeofday
AGE(timestamp, timestamp) Fonksiyonu


AGE(timestamp) Fonksiyonu
SELECT age(timestamp '2000-06-13')


CURRENT_DATE Fonksiyonu
SELECT current_date


CURRENT_TİME Fonksiyonu
SELECT current_time


CURRENT_TİMESTAMP Fonksiyonu
SELECT current_timestamp


DATE_PART(text, interval) Fonksiyonu
SELECT date_part('hour', timestamp '2000-01-16 19:07:40')


EXTRACT(field from timestamp) Fonksiyonu


EXTRACT(field from interval) Fonksiyonu


LOCALTİME Fonksiyonu
SELECT localtime


LOCALTİMESTAMP Fonksiyonu
SELECT localtimestamp


NOW() Fonksiyonu
SELECT now()


TİMEOFDAY() Fonksiyonu
SELECT timeofday()


Seda Sözer
SELECT extract(month FROM interval '3 years 5 months')
SELECT extract(hour FROM timestamp '2001-02-16 20:38:40')
SELECT age(timestamp '2002-05-11', timestamp '1967-07-13')