[PHP-DB] date format problem
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
RE: [PHP-DB] date format problem
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 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 _ Use fowl language with Chicktionary. Click here to start playing! http://puzzles.sympatico.msn.ca/chicktionary/index.html?icid=htmlsig -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Date format problem
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). Version: 6.0.502 / Virus Database: 300 - Release Date: 18/7/2003 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Date format problem
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 Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
