Hi, You should be able to use the following expression, given $seconds is your timestamp, to get a date-time. I am not sure about the limits on the number of seconds you can have in a duration, though:
xs:dateTime('1970-01-01T00:00:00+00:00') + xs:duration('PT' || $seconds || 'S') Regards, -- Florent Georges http://fgeorges.org/ http://h2oconsulting.be/ On 23 September 2016 at 09:14, Debin, Infant Jerald (LNG-CON) wrote: > Hi, > > > > Is there a way to convert the unix timestamp to HH/MM/SS format in marklogic > using xquery. > > > > Unit timestamp that is in xml is in below , > > > > <timestamp>1472812470453</timestamp> > > > > Thanks, > > Debin > > > _______________________________________________ > General mailing list > General@developer.marklogic.com > Manage your subscription at: > http://developer.marklogic.com/mailman/listinfo/general > _______________________________________________ General mailing list General@developer.marklogic.com Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general