Author Topic: Difference between Timestamp  (Read 886 times)

Offline dri

  • Full Member
  • ***
  • Join Date: Jan 2015
  • Posts: 11
  • Forum Citizenship: +0/-0
Difference between Timestamp
« on: 22 Apr 2016 02:27:18 pm »
I need to get difference between two timestamp in minutes like (1.43). It should not display minutes or secs in output.

start: 01/24/2015 08:57:27 PM
end:  01/24/2015 08:58:53 PM

Output: 1.43

Please help.

Offline dri

  • Full Member
  • ***
  • Join Date: Jan 2015
  • Posts: 11
  • Forum Citizenship: +0/-0
Re: Difference between Timestamp
« Reply #1 on: 22 Apr 2016 03:08:48 pm »
Got it!

Offline Raghuvir

  • Statesman
  • ******
  • Join Date: Aug 2013
  • Posts: 412
  • Forum Citizenship: +4/-4
Re: Difference between Timestamp
« Reply #2 on: 09 Aug 2017 12:51:18 am »
Got it!

would be of great help if you could post the solution.

Thanks in advance!

Offline chinnucognos

  • Community Leader
  • *****
  • Join Date: Nov 2013
  • Posts: 92
  • Forum Citizenship: +0/-0
Re: Difference between Timestamp
« Reply #3 on: 10 Aug 2017 08:18:29 am »
Try this,

extract(minute,<date_exp1>) - extract(minute,<dat_exp2>)
Deal with it!

 


       
Twittear