On Tue, January 15, 2008 12:31 pm, Adam Williams wrote: > Andrew Ballard wrote: > I don't see the point in needing to convert it to a timestamp. The > length_start and length_end fields in MySQL are defined as date > fields. > All I care about is the date, not the hours/minutes/seconds. If I > insert it as date('Y-m-d', $length_start) then when I SELECT it back > out, I will still have to do a date conversion back to MM-DD-YYYY when > I > display it to the user. No. MySQL is going to store it internally however it wants, regardless of how you get it in there. And you'll want to format it (or use MySQL default) independent of what you use to get it in there. -- Some people have a "gift" link here. Know what I want? I want you to buy a CD from some indie artist. http://cdbaby.com/from/lynch Yeah, I get a buck. So? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php