Hi Ambika,
Which version of MarkLogic Server are you using? Can you please post the exact
query and the output?
If you are using MarkLogic server 4.2 and above, here is another possibility to
print the dateTime in the format you want:
Q1)
let $dt:= xs:dateTime("2011-04-20T09:05:00.000-05:00")
return format-dateTime($dt,"[M01]-[D01]-[Y01] [h01]:[m01]:[s01] [Z]"),
returns: 04-20-11 09:05:00 -0500
Q2)
let $dt:= xs:dateTime("2011-04-20T09:05:00.000-05:00")
return format-dateTime($dt,"[M01]-[D01]-[Y01] [h01]:[m01]:[s01] [z]"),
returns: 04-20-11 09:05:00 GMT-05:00
Q3)
let $dt:= xs:dateTime("2011-04-20T09:05:00.000-05:00")
return format-dateTime($dt,"[M01]-[D01]-[Y01] [h01]:[m01]:[s01]")
returns: 04-20-11 09:05:00
Please note the [Z] in Q1, [z] in Q2 and neither in Q3. You can refer to W3C
XSLT 2.0 spec for the exact syntax of format-dateTime() picture string, if you
need more variations.
Do you have any particular question about time-zone and daylight savings in
MarkLogic that you are experimenting for?
Rgds,
Gajanan
From: [email protected]
[mailto:[email protected]] On Behalf Of ambika arumugam
Sent: Wednesday, April 20, 2011 11:59 PM
To: General MarkLogic Developer Discussion
Subject: [MarkLogic Dev General] Reg Time zone and daylight saving in marklogic
Hi all,
I was just trying to understand about the time zone and the daylight saving in
marklogic. The example I tried is as following:
1) I save a time with a time zone (say GMT -5:00 Eastern time (US and Canada))
(the data that I used looks like 2011-04-20T09:05:00.000-05:00)
2) I retrieve the time from the marklogic server and I pass the value to the
xdmp:strftime() function to format the obtained value in the MM-DD-YY HH:MM:SS
format.
3) In the output I obtain, I can see that the retrieved time is 1 hour ahead of
my local time. My current local time zone is GMT +5:30
Is this advancement in time due to the daylight saving time setting?
Can anyone please help me out?
Thanks in advance.
_______________________________________________
General mailing list
[email protected]
http://developer.marklogic.com/mailman/listinfo/general
