SitePoint Sponsor

User Tag List

Results 1 to 5 of 5

Thread: displaying date

  1. #1
    SitePoint Evangelist
    Join Date
    Apr 2003
    Location
    lisboa
    Posts
    423
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    displaying date

    hi
    i'm working on K Yank's book and, at some point, i've an insert like this:

    $sql = "INSERT INTO Jokes SET
    ...
    JokeDate = CURDATE()";

    When i dysplay this on my webpage, the date format is YYYY,MM,DD
    and in my country (Portugal), the format is day, month, year
    How can i achieve it?

  2. #2
    if($awake){code();} PHP John's Avatar
    Join Date
    Jul 2002
    Location
    Along the Wasatch Fault line.
    Posts
    1,771
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I have not played with it, but you may want to look into DATE_FORMAT() for mySQL.
    John

  3. #3
    SitePoint Evangelist Deano's Avatar
    Join Date
    Mar 2003
    Location
    Derbyshire, UK
    Posts
    487
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    HI rfl,

    I had the a simular problem and this is how it worked out for me..

    check out my postings : http://www.sitepointforums.com/showt...hreadid=105296

    I hope this helps !!

    GoodLuck
    Deano

  4. #4
    SitePoint Evangelist
    Join Date
    Apr 2003
    Location
    lisboa
    Posts
    423
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Perfect!
    Thanks a lot!

  5. #5
    SitePoint Evangelist Deano's Avatar
    Join Date
    Mar 2003
    Location
    Derbyshire, UK
    Posts
    487
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Glad I can be of assistance instead of me asking for Help !


Bookmarks

Posting Permissions

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