Converting unix timestamp in HTML

[Andrius Gasto]

Hello,

Could you please explain, how to convert timestamp string to normal date in HTML table?

An entry in the table looks like this:

<td bgcolor="#f4f4f4">
<%#Eval("MDate")%>
<td bgcolor="#f4f4f4">

[Sagar Rohankar]

Andrius Gasto wrote:
An entry in the table looks like this:

<td bgcolor="#f4f4f4">
<%#Eval("MDate")%>
<td bgcolor="#f4f4f4">

What do you mean by "entry in database"? Is the whole TD is coming from DB? If yes, then solution is not stright-forwward (ASAIK)

If you're using JSP, then try JSTL fmt

<fmt:formatDate value="${bean.date}" pattern="dd/MM/yyyy" />

And welcome to JavaRanch

[Andrius Gasto]

Thank you for a reply.

Well, I am taking data from the web site using API.

I tried doing something like this and it worked, however I had to use the java script:

date = <%#Eval("MDate")%>

var myDate = new Date(date * 1000);
date = myDate.toGMTString();

So I was interested if there is a way to do a straight conversion in this part <%#Eval("MDate")%>?
What I get in a <%#Eval("MDate")%> is a string like 1331554332 and I need to convert it to normal date.

[Andrius Gasto]

Could you please suggest a way of getting an array of strings from <%#Eval("MDate")%> ?

[Bear Bibeault]

Perhaps you could tell us what tools and frameworks you are using. That snippet of code is not HTML, CSS, JavaScript, or JSP. What is it?

[Andrius Gasto]

This part of the code is written in ASP.

[Bear Bibeault]

Ah, that explains it. ASP isn't discussed here.

[Andrius Gasto]

Well, I figured it myself. In case someone needs it:

<td bgcolor="#f4f4f4">
<script type="text/javascript">
date_conversion(<%#Eval("MDate")%>);
</script>
</td>

Javascript converts epoch to readable data and stores it in a table

<script type="text/javascript">
function date_conversion(date)
{
var myDate = new Date(date * 1000);
date = myDate.toGMTString();
var trimmed_date = date.substring(0, date.length-4) // Atmetamas GMT ir vienas tarpas
document.write(trimmed_date);
}
</script>