stig1 Posted May 11, 2009 Share Posted May 11, 2009 How do i convert a date/time 0000-00-00 00:00:00 into a string, and then convert back to a date/time? Basically i would like to store date/time values in a varchar field instead of a date/time field in mysql. Quote Link to comment Share on other sites More sharing options...
Maq Posted May 11, 2009 Share Posted May 11, 2009 How do i convert a date/time 0000-00-00 00:00:00 into a string, and then convert back to a date/time? You have to use the date function. Basically i would like to store date/time values in a varchar field instead of a date/time field in mysql. Why? Quote Link to comment Share on other sites More sharing options...
AmandaF Posted May 13, 2009 Share Posted May 13, 2009 In addition to PHP's date function, MySQL has a date_format function that does the same thing. You might find that that saves you from having to use varchar (you could store the date as a datetime and call date_format in the query). Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.