RE: [PHP-DB] date format problem

2007-12-22 Thread Bastien Koert 

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

2007-12-22 Thread arafat uddin 
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

2003-08-14 Thread Jennifer Goodie 
> 
> 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

[PHP-DB] Date format problem

2003-08-14 Thread Dani Matielo 
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