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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.