Help with date formatting

[cmccomas]

If I'm using a timestamp, and want the date to appear in this format:

12.10.03

How would I do that? That's month.day.year

Thanks

[kevinsequeira]

if you're using a mySQL TIMESTAMP field then it can only be of the format "YYYYMMDDHHMMSS"
however u can store it in this format and just display it differently using the Date() function in PHP

reg
kevin

[cmccomas]

I'm using a mySQL database and had a field "time" that is a "timestamp" field.

Can I still use the Date() function to format it, if so, how?

[weekender]

mysql timestamps are different to unix timestamps (as used by php) - in that mysql formats time as YYYYMMDDHHMMSS, whereas unix timestamps are the number of seconds since the beginning of the unix epoch (00:00 jan 1 1970).

to get the unix timestamp from mysql, put this in your sql statement

$sql = "SELECT UNIX_TIMESTAMP(time) AS time FROM...";

then, when you have that time field from the result, put it through [man]date[/man] to format it

date("m.d.y", $time);

adam

[kevinsequeira]

have a look at this

http://ca3.php.net/manual/en/function.date.php

try it out and if you still have a prob post the code.
reg
kevin