Information générale
Catégorie:
Codage, syntaxe et commandes
>Hi Sergey. It is DATETIME() type. Does it need to be handled differently in the BETWEEN() clause?
Think about it! Is the 3rd of June 2008 12:09 PM between 3rd of June 2008 12:00 AM and 3rd of June 2008 12:00 AM? No, it's after midnight, even after noon.
Your not querying a datetime being within a date, the date values are extended with 12 AM, so you would only find if a datetime is exactly midnight of that queried day...
Get it now, why you would add 1 to the end date? It's just so you get a real timespan you will query in.
Bye, Olaf.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement