TIMESTAMPDIFF is what I've been using. Not sure about the fractions component because that function returns an integer.
http://www-01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10. doc.sqlref/src/tpc/db2z_bif_timestampdiff.dita SF On 4/30/15, 8:53 AM, "David Ehresman" <david.ehres...@louisville.edu> wrote: >I'm having trouble with sql time again. I am trying to get >current_timestamp-backup_end from the filespaces table to display as days >and fractions of days. Any ideas? > >David
