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
KOD:
SELECT age(timestamp '1957-06-13')
KOD:
SELECT age(timsestamp '1992-01-26' , timestamp '1957-06-13')
KOD:
SELECT clock_timestamp()
Kod:
SELECT current_date
KOD:
SELECT current_time
Kod:
SELECT current_timestamp
Kod:
SELECT date_part('minute',timestamp '1992-01-26 21:45:00')
Kod:
SELECT extract(second FROM timestamp '1992-01-26 21:45:50')

Kod:
SELECT justify_days(interval '92 days')

Kod:
SELECT justify_hours(interval '37 days')
KOD:
SELECT localtime
KOD:
SELECT localtimestamp
KOD:
SELECT now()
KOD:
SELECT timeofday()
Süleyman AYDOSLU
Yorumunuzu Ekleyin