Skip to Content
0
Former Member
Nov 09, 2007 at 07:33 AM

Problems with datefromseconds in BLS

37 Views

Hi.

I am running xMII version 11.5, patch 3 and have a problem. If I try and run the following datefromseconds(0) it returns "0001-01-01T06:00:00". I would have expected "0000-00-00T00:00:00" or at least "0001-01-01T00:00:00"

A workaround could be ....

datefromseconds(

datetoseconds("0001-01-01T00:00:00") +

datediff("2007-09-12T09:44:53","2007-09-12T10:44:53"))

If I want a daterepresentation of the the timedifference...

BR.

Poul.