unix time code as date

raffael3d

I use this to fetch the timecode from the colum date:

$res = mysql_query("SELECT UNIX_TIMESTAMP(datum) FROM news where id=$edit");

how can I display it now as a normal date?

thanks.

cahva

Well, you could use for exapmle:
SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(datum))...

You didnt say which format do you want yor date to be. Normally I never say RTFM, but in this case it might be wise to check it out: Date and Time Functions

raffael3d

I thought I could do something like

print "$date (Y,f)";

I want day, month, year to display.

cahva

$res = mysql_query("SELECT DATE_FORMAT(FROM_UNIXTIME(UNIX_TIMESTAMP(datum)),'%e.%c.%Y') FROM news where id=$edit");

This will give you d.m.yyyy. If you want the date d-m-yyyy, just use '%e-%c-%Y' in your query.

If you want dd.mm.yyyy, then use '%d.%m.%Y' in your query.

Read the link I gave you, it explains a lot.

MrAlaska

PHP also gives you several methods to convert, format, and display timestamps in the manual:
http://www.php.net/manual/en/ref.datetime.php

Or you can find tutorials:
http://www.wdvl.com/Authoring/Languages/PHP/Date_Time/

philipolson

You could format it in your query or use PHP:

$timestamp = mysql_result($res, 0);
print date('Y m d, H:i:s', $timestamp);

raffael3d

the problem is, not it treats a MYSQL timestamp like a UNiX timestamp:

I use this code: how can I convert iit to a REAL date?

$res = mysql_query("select date from jobs WHERE id=$detail");

$timestamp = mysql_result($res, 0);

print date('d-m-Y, H:i:s', 55555);

philipolson

You forgot to use the mysql UNIX_TIMESTAMP command in your query this time.

raffael3d

thanks, but it didn' not solve the problem. the problem is, that it displays the timestamp wrong. if its changed to a date it says the date would be 19-01-2038, 04:14:07

which is not possible.

examancer

the best way is to format the date in the sql query, so you don't have to worry about it in php.

here are the date/time functions for mysql:
http://www.mysql.com/doc/en/Date_and_time_functions.html

that should be more than enough to do what you want.