/    Sign up×
Community /Pin to ProfileBookmark

Convert External XML Timestamp to Readable HTML Display with JScript

Greetings all,

I have an issue where I am having trouble converting an ISO8601 timestamp into a readable value. These timestamp values are located and grabbed from an external XML file and I need a simple way to convert it into a readable value before posting on an HTML page.

Here is the code I’m initially pulling the data with:

[CODE]<span id=”Created0″></span>
<span id=”Created1″></span>
<span id=”Created2″></span>
etc…

<script>
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject(“Microsoft.XMLHTTP”);
}
xmlhttp.open(“GET”,”externallink=xml”,false);
xmlhttp.send();
xmlDoc=xmlhttp.responseXML;

var i=0,d;
while (d=document.getElementById(“Created”+i)) d.innerHTML=xmlDoc.getElementsByTagName(“Created”)[i++].childNodes[0].nodeValue;
</script>[/CODE]

And an example of the external code from the XML file:

[CODE]<PostItems>
<member>
<Author>user:chayavic</Author>
<Body>@joelboss just saved someone’s Christmas. What have you done today? There’s still time. #c2alerts</Body>
<Topics>
<member>hashtag:c2alerts</member>
<member>user:joelboss</member>
</Topics>
<Created>2012-12-12T23:41:50.948Z</Created>
<Votes>
<DownVotes>0</DownVotes>
<UpVotes>2</UpVotes>
<UpVoters>
<member>
<Timestamp>2012-12-12T23:49:22.789Z</Timestamp>
<Voter>user:snyderm</Voter>
</member>
<member>
<Timestamp>2012-12-13T00:17:28.380Z</Timestamp>
<Voter>user:amyschra</Voter>
</member>
</UpVoters>
</Votes>
<PostId>da3316a1-bdda-40c6-8429-5d694ca6ecd3</PostId>
</member>[/CODE]

It appears to grab and display the “Created” items perfectly, but how would I render them out of the ISO8601 format into something readable, say “December 13th, 8:32pm” before actually defining it as a span? (Or even AFTER it defines them, then just modifies the value?)

Been banging my head against a wall trying to figure this one out ? Any help is appreciated!

to post a comment
JavaScript

1 Comments(s)

Copy linkTweet thisAlerts:
@ReFreezedDec 15.2012 — Take a look at the [U]Date[/U] object.
var dateString = '2012-12-12T23:41:50.948Z';
var date = new Date(dateString);
alert(dateString+'nn'+date.toLocaleString());
×

Success!

Help @sinsysonline spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 6.2,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,
)...