Date

[user4fun]

I have a form that allows the user to enter a date. This date is saved in an Mysql Table with the field type set to "date".It keeps saving the information in YYYY-MM-DD. Format.I need the user to enter the information in a simple format (ie MM-DD-YY. example 11-06-11)and when submitted, I need it to be stored as Tue Nov 6Please help.Starting point. Should I have dorp down boxes with all the weeks days, then another for the months, and another for the day? If so, will the information be stored in a manner that the php script can later compare dates?? and what if the user enters Tuesday Nov 6th, but november 6th is actually a wednesday?? I need it to be right.Thank you in advance.

[justsomeguy]

You don't change the way the date is stored. If you want to change the format of the date when you select it, you can, but if you're telling MySQL to store a date it's going to store it in its own format. Don't have your users pick the day, just the month, date, and year. You can also show a calendar where they can click on a date and see what day it is.http://dev.mysql.com/doc/refman/5.5/en/dat...ion_date-format

[user4fun]

OK, that is giving me some more ideas. Just so I understand how can I convert the YYYY-MM-DD format that is pulled from the table to the Wed Aug 10,2011 format that the webpage will display?, and when the user entered 08-11-2011 it will be converted to 2011-08-11 format before it is stored?Thank you for all your help

[thescientist]

you can use the date object and pass it a timestamp and then have it format the date you want. so if you get 08-11-2011

$userDate = '08-11-2011';$sqlDate = date('Y-m-d', strtotime($userDate));

you might just want to spend some time reading the date page in the PHP manual.http://php.net/manual/en/function.date.php

[justsomeguy]

The link I gave you to the MySQL manual shows the date_format function you can use to have MySQL return the date in whatever format you want.

[user4fun]

I am starting to learn morewaht is wrong with this?$full= $row['Ad_Start']; $y = date('Y', $full); echo $y;// y is giving me 1970 which is not the year in $full??

[thescientist]

what is the value of $full/$row['Ad_Start']?

[user4fun]

I tested itseveral time and came to this conclusionThe output is 1970 no matter what the value is. But then I print the original value right after taht, and itgive me the right one??

[user4fun]

$x= $row['Ad_Start']; $y = date('Y', $x); echo $y;echo "<br>";echo $row['Ad_Start'];

gives me19702012-08-29 // this is the orignal value.

[jeffman]

date expects a timestamp in the second parameter, not a formatted date string. You'll need to convert the string to a timestamp. strtotime will create a timestamp from a string. Note that this function has already been pointed out to you. When you visit the link, take the time to look at the left of your screen to review all the time functions available to you.FWIW, you'll save some trouble if you save your date as a timestamp in the database.

[thescientist]

$x= $row['Ad_Start']; $y = date('Y', $x); echo $y;echo "<br>";echo $row['Ad_Start'];

gives me19702012-08-29 // this is the orignal value.

you should re-read my first post. (post #4 in thread)I seconds DD's recommendation to use timestamps. I always prefer to have my times in that format in a database. Easier and more consistent for performing calculations and formatting.

[user4fun]

I forgot to thakn you for that earlier, I did use itand ti works great. I was trying to learn more things including the EXTRACT() and play arround with it to only pull out the year, then month, then day values independently to do more things with them.