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')
Yorumunuzu Ekleyin