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 ;-)
Well, for one thing, if ba_make_date is a DATETIME column, you're comparing it to what looks like a DATE value. That may make a difference, if the ba_make_date values don't have 00:00:00 in the time part.
What's the "CC" you're referring to?
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
--------------------------------------------------------------------- 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