cancel
Showing results for 
Search instead for 
Did you mean: 

how is the "datefromsecondsformatted( seconds, format)" function in BLS is returning the value?

Former Member
0 Kudos

Hello,

I have observed that for the value "39389 seconds", the function is returning "16:26 (HH:mm)" but it should return "10:56 (HH:mm) approx".

Why is it so? Can anybody let me know please.

Thanks and Best Regards

Venkatesh

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Venkatesh,

This is because it is showing in your local time zone.

Try this: datefromseconds(0) and it will show "0001-01-01T05:30:00" i.e. 0 means 05:30 in Indian Standard Time (IST).

This is why it is adding 5 hours and 30 mins to your time also.

Regards,

Rohit Negi.

Former Member
0 Kudos

hi Rohit, thank you.

Answers (0)