seconds into Minutes

[master_student]

Hello Guys,

I have an output in seconds. how to convert it into minutes.

Thanks

[master_student]

I would like to convert the result into minutes

[master_student]

no minutes

[master_student]

there was a mistake in the sql query, the value 48,511,346,498 in incorrcect. I would like to get a result in minutes

[Anil_Babu_Samineni]

From this input 48511346498 - What would be the output you want to see in minutes?

[master_student]

the input is incorrect sorry

[Anil_Babu_Samineni]

try to explain with sample data set and expected result set ?

[Chanty4u]

try this

num(floor([time])/3600,'##.##') as Min,

[master_student]

for example my input is in seconds 4000 s => result : 40 min

[PrashantSangle]

Hi,

If you get value in sec and you want to convert it into minutes then divide that value by 60 will work.

Regards,

[sunny_talwar]

How are you getting 40 mins from 4000 seconds?