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(){
$curdate=getdate(time());
$data_func=$curdate["year"]."-" .$curdate["mon"]."-" .$curdate["mday"] ;
return $data_func;
}
function quiet_time_stp_hora(){
$curdate=getdate(time());
$hora_func =
$curdate["hours"].":".$curdate["minutes"].":".$curdate["seconds"];
return $hora_func;
}
Rodrigo
-----------------------------------------------------------
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-feira, 18 de Novembro de 2004 18:47
Para: [EMAIL PROTECTED]
Assunto: [PHP-DB] timestamp problem
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
with MySQL versions above 4.1 - where the Timestamp has been modified to
have the ":" symbol in between the approprate numbers, as opposed to the
traditional extended format (i.e. 20041117104300), which can be found on
Mysql versions 4.0xx and below. I have > MySQL 4.1 on my local machine, but
MySQL 4.0 something on the box I'm publishing to - which is obviously the
more important box. So I need to get it working using the regular format.
And I don't want to just parse the characters because I have a bunch of
timestamp columns and don't really think it's that great of a resolution.
Any ideas?
thanks...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
