Re: [ADSM-L] sql time

Subject:	Re: [ADSM-L] sql time
From:	"Sergio O. Fuentes" <sfuentes AT UMD DOT EDU>
To:	ADSM-L AT VM.MARIST DOT EDU
Date:	Tue, 5 May 2015 14:19:11 +0000

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.ehresman AT LOUISVILLE DOT 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

<Prev in Thread]	Current Thread	[Next in Thread>
Re: [ADSM-L] sql time, Hanover, Cameron Re: [ADSM-L] sql time, David Ehresman Re: [ADSM-L] sql time, Jeanne Bruno Re: [ADSM-L] sql time, Hanover, Cameron Re: [ADSM-L] sql time, Sergio O. Fuentes <=

Previous by Date:	Re: [ADSM-L] sql time, Hanover, Cameron
Next by Date:	[ADSM-L] Node replication and authorized nodes, proxies, etc, Matthew McGeary
Previous by Thread:	Re: [ADSM-L] sql time, Hanover, Cameron
Next by Thread:	[ADSM-L] VME filespace rename, David Ehresman
Indexes:	[Date] [Thread] [Top] [All Lists]