List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:September 27 1999 10:08am
Subject:Re: date format
View as plain text  
On Mon, 1999-09-27 11:26:37 +0300, Yavuz SERT wrote:
> How can we change (or can we change) the format yyyy-mm-dd to
> dd-mm-yyyy ?

You can't change the internal format of date fields (and actually the
current ISO format is very good a choice!), but you can use
  DATE_FORMAT(date,format)
to display a date in any format you wish.

See chapter "7.3.11 Date and time functions" of the MySQL Reference
Manual.

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
date formatYavuz SERT27 Sep
  • Re: date formatMartin Ramsch27 Sep