i have two SQL queries:

SELECT column_name FROM table_name WHERE column_name >= '2010-07-01
00:00:00'
SELECT column_name FROM table_name WHERE column_name >= '2010-07-01'

the former returns dates starting at 2010-07-02 whereas the latter
returns dates starting at 2010-07-01. my question is... why aren't
they doing the same thing? if anything i would have expected the
second one to be the one that wasn't returning 2010-07-02 - not the
first one.

yawnmoth wrote:
statement, deserves all the confusion he gets IMHO :-)

On 2010-07-06 23:04, yawnmoth wrote:
What type is column_name and what version/engine are you using? Assuming
date and innodb your example works fine with:

mysql> select @@version;
+-----------+

mysql> create table T (c date not null) engine = innodb;
Query OK, 0 rows affected (0.07 sec)

mysql> insert into T values ('2010-07-01'),('2010-07-02');
Query OK, 2 rows affected (0.04 sec)
Records: 2 Duplicates: 0 Warnings: 0

mysql> select c from T where c >= '2010-07-01 00:00:00';
+------------+
2 rows in set (0.02 sec)

mysql> select c from T where c >= '2010-07-01';
+------------+
2 rows in set (0.00 sec)


/Lennart

On Tue, 6 Jul 2010 14:04:33 -0700 (PDT), yawnmoth wrote:
But it's the first all day! It can't be greater than the first until
it's not the first anymore. What day would that be?

--
30. All bumbling conjurers, clumsy squires, no-talent bards, and
cowardly thieves in the land will be preemptively put to death. My
foes will surely give up and abandon their quest if they have no
source of comic relief. --Peter Anspach's Evil Overlord list