DekGenius.com
Home
(current)
Dictionary
BOOKS
LYRICS
CHORD
SCRIPT & CODE EXAMPLE
Karaoke language
Search
Go
SCRIPT & CODE EXAMPLE
CODE EXAMPLE FOR SQL
postgresql get difference in hours between two dates
select EXTRACT( EPOCH FROM now() - (now() - INTERVAL '5 HOUR') )/3600 -- it will return 5
Source by stackoverflow.com #
PREVIOUS
NEXT
Tagged:
#postgresql
#difference
#hours
#dates
ADD COMMENT
Topic
COMMENT
Name
9+8 =
Submit