RE: Date format problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> 
> I have a field in my mysql db wich is a timestamp with the format
> 
> yyyymmddhhmmss
> 
> and I would like to display it like:
> 
> dd/mm/yyyy
> 
http://www.mysql.com/doc/en/Date_and_time_functions.html#IDX1333

SELECT DATE_FORMAT(timestamp_col_name, '%d/%m/%Y') FROM table_name

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux