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
Dat
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 onl
Hi
Does it help?
function time_stp(){
$curdate=getdate(time());
echo $curdate["weekday"]. " ".$curdate["mday"]." ".$curdate["month"]."
".$curdate["year"];
echo "";
echo $curdate["hours"].":".$curdate["minutes"].":".$curdate["seconds"];
}
function quiet_time_stp_data(){
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 pr
> 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.