Ciao a tutti, ho un problema nel fare una select di una data inizio e
data fine


AND (dataSpedizione <= date(now()) AND dataSpedizione <
DATE_ADD(date(now()),Interval 1 day)) GROUP BY idSpedizioni

non mi recupera tutte le "spedizioni" del giorno


cosa sbaglio??

Sarah wrote:
> Ciao a tutti, ho un problema nel fare una select di una data inizio e
> data fine
>
>
> AND (dataSpedizione <= date(now()) AND dataSpedizione <
> DATE_ADD(date(now()),Interval 1 day)) GROUP BY idSpedizioni
>
> non mi recupera tutte le "spedizioni" del giorno
>
>
> cosa sbaglio??


TRANSLATED:


Hello everyone, I have a problem in doing a select a start date and end date


> AND (dataSpedizione <= date(now()) AND dataSpedizione <
> DATE_ADD(date(now()),Interval 1 day)) GROUP BY idSpedizioni

I do not recover all "shipments" of the day


What mistake?

================================================== =============


mysql> select now(),DATE_ADD(date(now()),Interval 1 day) as next;
+---------------------+------------+
| now() | next |
+---------------------+------------+
| 2008-03-24 17:10:49 | 2008-03-25 |
+---------------------+------------+

your query gets ALL data:

mysql> select * from ship where
-> (a <=now() and a < DATE_ADD(date(now()),Interval 1 day));
+------+---------------------+
| t | a |
+------+---------------------+
| 1 | 2008-03-24 17:13:49 |
| 2 | 2008-03-24 17:13:55 |
| 3 | 2008-03-24 17:14:01 |
| 4 | 2006-03-24 00:00:00 |<<<<---YEAR is 2006
| 4 | 2005-03-24 17:13:00 |<<<<---YEAR is 2005
+------+---------------------+
5 rows in set (0.00 sec)


Try:

mysql> select * from ship where a > cast(Now() as date) and a < now();
+------+---------------------+
| t | a |
+------+---------------------+
| 1 | 2008-03-24 17:13:49 | <<--TODAY
| 2 | 2008-03-24 17:13:55 | <<--TODAY
| 3 | 2008-03-24 17:14:01 | <<--TODAY
+------+---------------------+
3 rows in set (0.00 sec)

>
> mysql> select now(),DATE_ADD(date(now()),Interval 1 day) as next;
> +---------------------+------------+
> | now() | next |
> +---------------------+------------+
> | 2008-03-24 17:10:49 | 2008-03-25 |
> +---------------------+------------+
>
> your query gets ALL data:
>
> mysql> select * from ship where
> -> (a <=now() and a < DATE_ADD(date(now()),Interval 1 day));
> +------+---------------------+
> | t | a |
> +------+---------------------+
> | 1 | 2008-03-24 17:13:49 |
> | 2 | 2008-03-24 17:13:55 |
> | 3 | 2008-03-24 17:14:01 |
> | 4 | 2006-03-24 00:00:00 |<<<<---YEAR is 2006
> | 4 | 2005-03-24 17:13:00 |<<<<---YEAR is 2005
> +------+---------------------+
> 5 rows in set (0.00 sec)
>
>
> Try:
>
> mysql> select * from ship where a > cast(Now() as date) and a < now();
> +------+---------------------+
> | t | a |
> +------+---------------------+
> | 1 | 2008-03-24 17:13:49 | <<--TODAY
> | 2 | 2008-03-24 17:13:55 | <<--TODAY
> | 3 | 2008-03-24 17:14:01 | <<--TODAY
> +------+---------------------+
> 3 rows in set (0.00 sec)



Thanks for help me!!! and Excuse me for the language ... I haven't seen
the language of the newsgroup!