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

[Former Member]

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

[Former Member · Accepted solution]

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 · Accepted solution]

hi Rohit, thank you.