I have a database that stores documents relating to meetings. They have all the
usual stuff agenda, minutes etc. There are 3 paper types for each date agenda
(1 only), minutes (1 only), and a bunch of general documents titled 'papers'.
I need to display all the documents for a specific date
-02 and order by that.
/Peter
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 02, 2006 3:04 PM
To: mysql@lists.mysql.com
Subject: Getting the previous months documents
I have a database that stores documents relating to meetings. They have all
to change the field to DATE?
Ross
- Original Message -
From: Peter Lauri [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, May 02, 2006 9:06 AM
Subject: RE: Getting the previous months documents
You should start by using MySQL date as the standard for date: -MM-DD
After
have to change the field to DATE?
Ross
- Original Message -
From: Peter Lauri [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, May 02, 2006 9:06 AM
Subject: RE: Getting the previous months documents
You should start by using MySQL date as the standard for date: -MM-DD
:20 AM
Subject: RE: Getting the previous months documents
I did this, sorry for bad format. This will do it for you.
SELECT CONCAT(SUBSTRING(temptext, 7, 2),SUBSTRING(temptext, 4, 2),
SUBSTRING(temptext, 1, 2)) AS docdate
FROM `tempdate` WHERE CONCAT(SUBSTRING(temptext, 7, 2),SUBSTRING(temptext