Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 N eed Help

Author  Topic 

derozza
Starting Member

13 Posts
Posted - 2011-01-16 : 22:20:59
I experiencing problem in executing query on between date command. I got wrong result.

MySQL Syntax



SELECT approval_date FROM itemdetail WHERE approval_date BETWEEN '01/01/2011' AND '15/01/2011'

My Record in Mysql Database:
SELECT approval_date
       FROM itemdetail
       WHERE approval_date BETWEEN '01/01/2011' AND '15/01/2011'

|Approval Date|
05/01/2011
10/12/2010
12/12/2010
15/12/2010
10/01/2011

|Result|
Like above

Need result
|Approval Date|
05/01/2011
10/10/2011

Anyone could help me. how to get the needed result. sorry am still new in mysql.

Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2011-01-17 : 06:44:15
This is a Microsoft SQL Server forum.
Try your luck over at dbforums.com


N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site