Jump to content

Archived

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

reazik

UNIX time

Recommended Posts

Help!

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>
</tr>
</table>

(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..

[code]<?PHP

$my_timestamp = time();

echo date("m d, Y", $my_timestamp);
?>[/code]

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

Lite...

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.