Convert date column to seconds

[Anon Anon]

HI,

 

IN Infoview, i am creating a report on target_time folder. In that, time left column is displaying the o/p  as date whereas in SQL it is displaying the o/p in seconds. How can i get the column o/p in seconds in infoview. Any ideas?

 

Thanks

Madhavi.

[Kyle_R]

Hi,

Try this post: [Deski (XI)] Changing the time portion of timestamp

 

(But there's probably a better way! ! ! )

 

Thanks, Kyle_R.

[sudip.bhowmik]

you could use the link kyle mentioned to get that in secs but why do you wanna do that in the first place?