472,139 Members | 1,673 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,139 software developers and data experts.

where.. between


i'm doing a program about searching. but, i have some probem when using 'between'. this is my program:

SELECT eID, REPLACE(eTitle, '''', '''')as eTitle, REPLACE(eDescription, '''', '''')as eDescription, eSystemID, eDateStart, eDateEnd, eDurationSet, eDateCreated, eAuthorID, eTemplate, eStatus FROM vm_examdb.vm_examset WHERE eStatus = 'Approved' BETWEEN DATE_FORMAT(eDateStart, '%Y-%m-%d') <= '2006-06-21' AND DATE_FORMAT(eDateEnd, '%Y-%m-%d') >= '2006-06-21' OR DATE_FORMAT(eDateStart, '%Y-%m-%d') = '0000-00-00' ORDER BY eID ASC

the problem is, the system does not sort the eStatus = 'Approved'.
can anyone help me
Jun 21 '06 #1
1 3648
hy sakurasyi

try to change data format dd-mm-yyy, or check format columns in the table. Evrithing in write correct

Jul 6 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Rachel Weeden | last post: by
17 posts views Thread by Jonas Rundberg | last post: by
1 post views Thread by mychevworld | last post: by
8 posts views Thread by Mike Charney | last post: by
23 posts views Thread by gord | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.