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

    Join Date
    Feb 2000
    Posts
    33
    Rep Power
    15
    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
    Location
    London
    Posts
    987
    Rep Power
    15
    This can be done with Date_Format() function in mysql.

    See the manual for the details.


    ------------------
    SR -
    shiju.dreamcenter.net

Similar Threads

  1. Loop To Update Column Value Using Cron
    By Volitics in forum PHP Development
    Replies: 0
    Last Post: January 26th, 2004, 01:28 PM
  2. Replies: 2
    Last Post: September 20th, 2003, 01: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, 12:41 PM
  4. Using LOAD DATA LOCAL INFILE on remote server
    By starlucky in forum MySQL Help
    Replies: 4
    Last Post: April 24th, 2003, 06: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, 03:23 AM

IMN logo majestic logo threadwatch logo seochat tools logo