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
-
Rodrigo Cabeceiras
-
Rua do Ameal nº 507 5º Esq
4200-061 Porto
-
Tel.:917776045
msn: [EMAIL PROTECTED]
-
web: www.rodrigocabeceiras.pt.to
---------
-Mensagem original-
De: Doug Parker [mailto:[EMAIL PROTECTED]
Enviada: quinta-
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: [P
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 only appears to work
w
> 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.
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 there a
