Hi, perform the following query
SELECT BA_ID, BA_DATE
FROM BA
WHERE SUBSTRING(BA_ID,1,3) = 'TSV'
and get
'TSV12345-00001','2003-02-25 00:00:00'
'TSV12345-00002','2003-02-25 00:00:00'
'TSV14818-00003','2003-02-19 00:00:00'
'TSV14836-00015','2003-02-27 00:00:00'
'TSV14841-00009','2003-02-28 00:00:00'
which is OK. When I only want data from 2/25/2003 and query with
SELECT BA_ID, BA_DATE
FROM BA
WHERE SUBSTRING(BA_ID,1,3) = 'TSV'
AND BA_DATE = '2003-25-2'
I get 0 rows returned....
The book hinted at using DATE_FORMAT which I did
SELECT BA_ID, BA_DATE
FROM BA
WHERE SUBSTRING(BA_ID,1,3) = 'TSV'
AND BA_DATE = DATE_FORMAT('2003-25-2', '%y-%d-%m')
But still 0 rows... D'OH... What am I missing here? Thanks for any
help... I would hate to have to tell the boss we're going back to
VB-ADO-MSAccess ;-)
Jeff
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
