Hi all. I have spent some time studying the manual and previous posts, trying to get a grip on the whole date_format issue... I am VERY new to MySQL having been converted from an ADO/DAO environment with Access dBs...
Where I am having trouble is coming up for a syntax to SELECT * FROM tableA WHERE ba_id_num = 'ABC12345' AND ba_make_date = '2003-25-2' ba_id_num = varchar(8) ba_make_date = datetime Even though I can see several rows from the CC, the query returns 0... I have unsuccessfully attempted to use the DATE_FORMAT function also. Any hint of where I am going wrong would be greatly appreciated ;-) 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
