[ale] Searching by dates in MySQL

James Sumners james at sumners.ath.cx
Wed Aug 25 17:52:39 EDT 2004


It would probably help if I used the correct date function:

SELECT col1, DATE_FORMAT(date_col, "%c-%d-%y") as dtime WHERE dtime BETWEEN
'8-18-04' AND '8-25-04';


On Wed, 25 Aug 2004 17:38:33 -0400
James Sumners <james at sumners.ath.cx> wrote:

>  SELECT col1, DATE(date_col, "%c-%d-%y") as dtime WHERE dtime BETWEEN
>  '8-18-04' AND '8-25-04';

-- 
James Sumners
http://ug.dyndns.org/~jsumners/

"All governments suffer a recurring problem: Power attracts pathological
personalities. It is not that power corrupts but that it is magnetic to the
corruptible. Such people have a tendency to become drunk on violence, a
condition to which they are quickly addicted."

Missionaria Protectiva, Text QIV (decto)
CH:D 59



More information about the Ale mailing list