my problem is with date format
mysql support -mm-dd
but my client not use to enter date in -mm-dd format
he use to in dd-mm-yyy format
how can it possible to input date in
dd-mm- format
www.php.net/date will show you all the possibilities of formatting the date
bastien
Date: Sat, 22 Dec 2007 17:54:07 +0600
From: [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] date format problem
my problem is with date format
Hello,
I have a field in my mysql db wich is a timestamp with the format
mmddhhmmss
and I would like to display it like:
dd/mm/
how do I do that?
Thank you in advance,
Dani
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
I have a field in my mysql db wich is a timestamp with the format
mmddhhmmss
and I would like to display it like:
dd/mm/
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