Xordal/minuteDiff.sql

Last active January 1, 2016 12:09

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Xordal/8142974.js"></script>
Save Xordal/8142974 to your computer and use it in GitHub Desktop.

Download ZIP

DateDiff(min, :toDate, :fromDate) for PostgreSql

Raw

minuteDiff.sql

SELECT extract(epoch from (to_timestamp(:toDate, 'DD.MM.YYYY HH24:MI') - to_timestamp(:fromDate, 'DD.MM.YYYY HH24:MI'))) / 60

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment