Comment by akmal on 2004-07-15
first of all, the code will give errors. mktime() is used to make a unix timestamp for a date. i don't see the need for mktime() to generate today's date. also the quoting is wrong.
the correct code will be:
echo "Today's date in MySQL format is ".date('Y-m-d');
Comment by Shanmugasundaram on 2005-03-24
Very good
Comment by lakshmi on 2005-12-12
Tell me how to insert value into date datatype in mysql
Comment by heena on 2005-12-30
extremely helpful!!
Comment by Sanjeev Kumar on 2006-01-10
This code is not correct
use this one
Comment by Sourav Bose on 2006-12-21
From Oracle table when i create *.txt file or *.csv file the date fields will returns dd-mon-yy format. But MySql is inserted yyyy-mm-dd. How can is possible for to insert date field. My code is in ASP.Another thing dd-mon-yy is return as string type.
Comment by Stafon on 2011-05-21
AFAIC that's the best aenswr so far!
Comment by discount Michael Jordan Shoes on 2010-09-17
Air Jordan Shoes are always so attractive, good quality can ensure the wearer's feet, not only that, the Michael Jordan Shoes has become a fashion, many young people are very fanatical Air Jordan. High price so many people can realize their dreams. Well now, our products directly from third-party products, so we can provide cheap Jordan Basketball Shoes and New Jordan Shoes, high quality, excellent service, come on, give yourself a choice.
We offerAir Jordan 1, Air Jordan 2, Air Jordan 3,Air Jordan 4, Air Jordan 5, Air Jordan 6, Air Jordan 7, Air Jordan 8, Air Jordan 9, Air Jordan 10, Air Jordan 11 and so on!
|