Selecting Dates

Hi All,

Switching from Oracle to MySQL, I seem to be having some difficulty =
selecting dates using between or even where >=3D and <=3D like:

SELECT * FROM orders WHERE order_date BETWEEN=3D'2010-01-01' AND =
'2010-01-30' ORDER BY order_date;

or

SELECT * FROM orders WHERE order_date =3D>'2010-01-01' AND <=3D =
'2010-01-30' ORDER BY order_date;

Neither of these work.

What am I missing?

-ML

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Selecting Dates

--0-1849690057-1265034212=:93317
Content-Type: text/plain; charset=us-ascii

Just trying to help.

SELECT * FROM orders WHERE order_date BETWEEN '2010-01-01' AND
'2010-01-30' ORDER BY order_date;

or

SELECT * FROM orders
WHERE order_date >= '2010-01-01' AND <= '2010-01-30' ORDER BY
order_date;





________________________________
From: ML
To: mysql@lists.mysql.com
Sent: Mon, February 1, 2010 8:35:01 AM
Subject: Selecting Dates

Hi All,

Switching from Oracle to MySQL, I seem to be having some difficulty selecting dates using between or even where >= and <= like:

SELECT * FROM orders WHERE order_date BETWEEN='2010-01-01' AND '2010-01-30' ORDER BY order_date;

or

SELECT * FROM orders WHERE order_date =>'2010-01-01' AND <= '2010-01-30' ORDER BY order_date;

Neither of these work.

What am I missing?

-ML

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=luckyx_cool_boy@yahoo.com



--0-1849690057-1265034212=:93317--

Re: Selecting Dates

SGkNCldoYXQgaXMgdGhlIGRhdGF0eXBlIG9mIHRoZSBjb2x1bW4gb3JkZXJf ZGF0ZS4gR2l2ZSB0
aGUgZnVsbCBmb3JtIG9mIHRoZSBkYXRlIGZvciB0aGUgYmV0d2VlbiBjb25k aXRpb24uDQoNClRo
YW5rcw0KU3VyZXNoIEt1bmENCk15U1FMIERCQQ0KLS0tLS0tT3JpZ2luYWwg TWVzc2FnZS0tLS0t
LQ0KRnJvbTogTUwNClRvOiBteXNxbEBsaXN0cy5teXNxbC5jb20NClN1Ympl Y3Q6IFNlbGVjdGlu
ZyBEYXRlcw0KU2VudDogRmViIDEsIDIwMTAgNzowNSBBTQ0KDQpIaSBBbGws DQoNClN3aXRjaGlu
ZyBmcm9tIE9yYWNsZSB0byBNeVNRTCwgSSBzZWVtIHRvIGJlIGhhdmluZyBz b21lIGRpZmZpY3Vs
dHkgc2VsZWN0aW5nIGRhdGVzIHVzaW5nIGJldHdlZW4gb3IgZXZlbiB3aGVy ZSA+PSBhbmQgPD0g
bGlrZToNCg0KU0VMRUNUICogRlJPTSBvcmRlcnMgV0hFUkUgb3JkZXJfZGF0 ZSBCRVRXRUVOPScy
MDEwLTAxLTAxJyBBTkQgJzIwMTAtMDEtMzAnIE9SREVSIEJZIG9yZGVyX2Rh dGU7DQoNCm9yDQoN
ClNFTEVDVCAqIEZST00gb3JkZXJzIFdIRVJFIG9yZGVyX2RhdGUgPT4nMjAx MC0wMS0wMScgQU5E
IDw9ICcyMDEwLTAxLTMwJyBPUkRFUiBCWSBvcmRlcl9kYXRlOw0KDQpOZWl0 aGVyIG9mIHRoZXNl
IHdvcmsuDQoNCldoYXQgYW0gSSBtaXNzaW5nPw0KDQotTUwNCg0KLS0NCk15 U1FMIEdlbmVyYWwg
TWFpbGluZyBMaXN0DQpGb3IgbGlzdCBhcmNoaXZlczogaHR0cDovL2xpc3Rz Lm15c3FsLmNvbS9t
eXNxbA0KVG8gdW5zdWJzY3JpYmU6ICAgIGh0dHA6Ly9saXN0cy5teXNxbC5j b20vbXlzcWw/dW5z
dWI9c3VyZXNoa3VtYXJpbHVAZ21haWwuY29tDQoNCg0KDQpTZW50IGZyb20g QmxhY2tCZXJyea4g
b24gQWlydGVs

Re: Selecting Dates

--0016e6d778ed30e92b047e8adc38
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Shouldn't it be:
SELECT * FROM orders WHERE order_date >=3D '2010-01-01' AND order_date <=3D
'2010-01-30' ORDER BY order_date;

?

change the "=3D>" and repeat the column_name. Datetime should be datetime =
or
timestamp;

On Mon, Feb 1, 2010 at 8:25 AM, wrote:

> Hi
> What is the datatype of the column order_date. Give the full form of the
> date for the between condition.
>
> Thanks
> Suresh Kuna
> MySQL DBA
> ------Original Message------
> From: ML
> To: mysql@lists.mysql.com
> Subject: Selecting Dates
> Sent: Feb 1, 2010 7:05 AM
>
> Hi All,
>
> Switching from Oracle to MySQL, I seem to be having some difficulty
> selecting dates using between or even where >=3D and <=3D like:
>
> SELECT * FROM orders WHERE order_date BETWEEN=3D'2010-01-01' AND '2010-01=
-30'
> ORDER BY order_date;
>
> or
>
> SELECT * FROM orders WHERE order_date =3D>'2010-01-01' AND <=3D '2010-01-=
30'
> ORDER BY order_date;
>
> Neither of these work.
>
> What am I missing?
>
> -ML
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=3Dsureshkumarilu@gmail.co m
>
>
>
> Sent from BlackBerry=AE on Airtel




--=20
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com

--0016e6d778ed30e92b047e8adc38--

Re: Selecting Dates

Jim,

> Shouldn't it be:
> SELECT * FROM orders WHERE order_date >=3D '2010-01-01' AND order_date =
<=3D '2010-01-30' ORDER BY order_date;
>=20
> ?
>=20
> change the "=3D>" and repeat the column_name. Datetime should be =
datetime or timestamp;

Spot on. Thank you for the clarification, obviously a syntax mistake on =
my part.

-ML=

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Selecting Dates

On Jan 31, 2010, at 7:35 PM, ML wrote:

> Hi All,
>
> Switching from Oracle to MySQL, I seem to be having some difficulty selecting dates using between or even where >= and <= like:
>
> SELECT * FROM orders WHERE order_date BETWEEN='2010-01-01' AND '2010-01-30' ORDER BY order_date;

No "=" after BETWEEN.

>
> or
>
> SELECT * FROM orders WHERE order_date =>'2010-01-01' AND <= '2010-01-30' ORDER BY order_date;

Need "order_date <=", not just "<=".

>
> Neither of these work.
>
> What am I missing?
>
> -ML

--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org