1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2000
    Rep Power
    hi again a question ;-)

    with this function i get the local dayname
    month, etc ...
    setlocale ("LC_TIME", "nl_NL");
    print(strftime("%A, %e %B %Y"));
    echo " n";

    but i want to display dates from my mysql
    database in the local format.

    how about that ??

    thanks for any help !

    Devshed really is a very good help !

    Jan The Netherlands.
  2. #2
  3. .Net Developer
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Rep Power
    This can be done with Date_Format() function in mysql.

    See the manual for the details.

    SR -

Similar Threads

  1. Loop To Update Column Value Using Cron
    By Volitics in forum PHP Development
    Replies: 0
    Last Post: January 26th, 2004, 12:28 PM
  2. Replies: 2
    Last Post: September 20th, 2003, 12:49 PM
  3. Just a puzzle- to find day, given the date
    By murugesan in forum C Programming
    Replies: 7
    Last Post: September 16th, 2003, 11:41 AM
  4. Using LOAD DATA LOCAL INFILE on remote server
    By starlucky in forum MySQL Help
    Replies: 4
    Last Post: April 24th, 2003, 05:44 PM
  5. best way to print local name of the day etc..
    By smeelen in forum PHP Development
    Replies: 3
    Last Post: May 3rd, 2000, 02:23 AM

IMN logo majestic logo threadwatch logo seochat tools logo