Having a problem with a Date data type.
Here's the query:
SELECT distinct date_format(auditdate, "%Y%M" ) as listUrl, date_format(
auditdate, "%Y%m" ) as blank
FROM quality_history
WHERE auditdate <> Now()
ORDER BY listUrl desc
LIMIT 6
auditdate is a DATE datatype
When I
Okay, here's an interesting one. Here's the query:
SELECT distinct date_format(auditdate, "%Y%M" ) as listUrl, date_format(
auditdate, "%Y%m" ) as blank
FROM quality_history
WHERE auditdate <> Now()
ORDER BY listUrl desc
LIMIT 6
auditdate is a DATE datatype
When I run thi
Howdy all...
New to MySQL and I've got a question. I have an application that does a
good deal of hierarchical reporting. In order to do this one of the tables
in my database contains nothing more than an individuals id and the team to
which that individual reports
TABLE - TEAMREPORT
