Results 1 to 2 of 2

Thread: Changing Date Format in mysql

  1. 12-11-2008, 02:04 AM #1
    ashokvissu
    ashokvissu is offline Registered User
    Join Date
    Dec 2008
    Posts
    1

    Exclamation Changing Date Format in mysql

    Hi All,

    Is there any possibility to change the date format in mysql to dd/mm/yyyy format.If Possible please explain me with an example.


    Thanx.
    Reply With Quote Reply With Quote
  2. 12-27-2008, 10:19 AM #2
    polarbear
    polarbear is offline Registered User
    Join Date
    Dec 2008
    Posts
    1

    Set any date format using date_format

    Using date_format you can set any date format:

    select date_format(FromDate,"%d/%m/%Y") AS FormattedDate FROM tbl_event

    See http://dev.mysql.com/doc/refman/5.1/...on_date-format for complete list of format specifiers.

    Regards
    The Polar Bear
    Last edited by polarbear; 12-27-2008 at 10:21 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules