Jump to content


This topic is now archived and is closed to further replies.


UNIX time

Recommended Posts


I'm still working on creating a job bulletin for my company and I'm a newbie, so it's not easy.

I want each job to reflect the last date it was updated. Fortunately, there's already an SQL entry that does that for me, but it comes up as UNIX time.

Here's the code I'm using:

<table width="90%">
<tr valign="top" {ALTERNANCE}>
<td width="30" class="style1"><a href="details.php?id={JOB_ID}" class="style2">{JOB_NAME_TITLE}</a></td>
<td width="60" align="center" class="style1">{JOB_DATE}</td>
<td width="200" class="style1">{JOB_LOCATION_TITLE}</td>
<td width="210" colspan="2" class="style1">{JOB_SUMMARY}</td>

(look at [a href=\"http://psninc.net/forms/JobBulletin2/list.php\" target=\"_blank\"]http://psninc.net/forms/JobBulletin2/list.php[/a] for results)

How do I "translate" the {JOB_DATE} into a 0-00-0000 format?

P.S. When I tried to change the number in myPHPAdmin from an integer to a date, it got rid of all of the data, so I don't want to do that again.

Is my question clear enough? Or do I need to provide more information.

Waiting with baited breath....

Thank you in advance for any guidance you can give me...

Share this post

Link to post
Share on other sites
Try this..


$my_timestamp = time();

echo date("m d, Y", $my_timestamp);

then read here [a href=\"http://us3.php.net/date\" target=\"_blank\"]http://us3.php.net/date[/a]


Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.