this is a common mysql timestamp problem, you can try using
DATE_FORMAT(datefield, FORMAT) sql function to define the date, or store the
timestamp as a unix timestamp (an integer) from the get go
bastien
From: Doug Parker [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] timestamp
Hi
Does it help?
function time_stp(){
$curdate=getdate(time());
echo $curdate[weekday]. .$curdate[mday]. .$curdate[month].
.$curdate[year];
echo BR;
echo $curdate[hours].:.$curdate[minutes].:.$curdate[seconds];
}
function quiet_time_stp_data(){
Doug Parker wrote:
I'm trying to format a MySQL Timestamp Column Type with PHP, and it's not
going well. In reading up on it, I see that the idea is to convert the
Timestamp type to Unix format using the strtotime() function, then using the
date() function to format that result. However, this
Ok, thanks for the input. I knew that was an option as well, the problem is
that I have about eight different dates in the query, and I'd rather do a
query like SELECT projects.* FROM projects... and then format those
results, rather than do SELECT DATE_FORMAT('%m %d %Y', projects.Date1) AS
I'm using the timestamp column type in a database, and the only
problem
is that it the stamp is three hours prior to the actual post when I
post
to a remote server. I'm assuming, since it works fine on my machine,
that this is because the remote server I am is in a different time
zone. Is
