Information générale
Catégorie:
Codage, syntaxe et commandes
CTOD() is also ambiguous. Be vary careful.
Dave
>>I'm resetting a filter with a date literal and it suddenly became... AMBIGUOUS!
>
>I'd suggest using a CTOD() on an index and then filtering on that. There's another reason too, sometimes doing a seek on a datetime will fail, and you don't know why. Its because the DateTime actually store the millisecond in the table, but its not possible to specify the millisecond in a variable, so the seek rarely finds a match, even though one should exist. CTOT() solves that.
>
>By the way, I liked Larry's suggestion, its pretty sneaky!
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