Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
MySQL Date Formatting - Garbled Date Insert
sleipnir214, Thanks for your responses, but they've been no help whatsoever. Write a whole bunch of code to reformat the date in and out of the database. Never would have thought of that! Genius. I am not and never have expected a bundled Microsoft solution, the only MS aspect involved is... -
MySQL Date Formatting - Garbled Date Insert
sleipnir214, No need to *sigh*, unless a show of disdain was your intent. I'm familiar with the MySQL documentation, but as I mentioned earlier, my TIMESTAMP is not being entered in the YYYY-MM-DD HH:MM:SS format and neither is the DATE field, which is the whole point of this thread, but thank... -
MySQL Date Formatting - Garbled Date Insert
sleipnir214, >I don't know where your timestamp information is coming from. On my system timestamp reports the information as YYYY-MM-DD HH:MM:SS.< Not on any of mine - I've three MySQL installations running, one on XP and another on Windows 98 (both local network) and a third on my Windows... -
MySQL Date Formatting - Garbled Date Insert
sleipnir214, >MySQL's date format is YYYY-MM-DD.< I don't follow... are you saying all dates in MySQL have to be yyyy/mm/dd? If so, that doesn't appear to be the case. For example, a TIMESTAMP field is mm/dd/yyyy hh:mm:ss. Or are you saying that just the DATE field datatype has to be... -
MySQL Date Formatting - Garbled Date Insert
Guys, I’ve recently converted a site from Access 2002 databases to MySQL, but am having an issue with MySQL’s date field. On the site there is an insert record page consisting of two fields. One is a headline, the other a date. The default value in the date field is completed via the <% Date...
