Win! On Tue, 24 May 2016 5:21 pm Nyall Dawson <[email protected]> wrote:
> On 23 May 2016 at 21:21, Richard Duivenvoorde <[email protected]> wrote: > > Nyall Dawson schreef op 2016-05-23 11:41: > >>> > >>> But now it would be cool to check the time-difference between those two > >>> (called timespan?). > >>> I did not find a function for those... > >> > >> > >> Use the age() function. That takes two datetimes and returns an > >> interval length between them. You can extract the > >> seconds/minutes/hours/etc from an interval type using the seconds(), > >> minutes(), ... etc functions. > >> > >> Hope that helps! > > > > > > Ah :-) definitely... Did find see that one... > > FYI - as of https://github.com/qgis/QGIS/commit/8ddcf76 you can now > just directly calculate date/time/datetime differences using "-", eg > > to_date('2016-03-04')-to_date('2016-03-01') > > This will return an interval object which you can then use seconds(), > minute(), etc on. > > Nyall > > > > > > Thanks! > > > > Richard > _______________________________________________ > Qgis-developer mailing list > [email protected] > List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
_______________________________________________ Qgis-developer mailing list [email protected] List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
