Search on Time

11/08/2006, 21h57

Is there anyway to search based on a time or is it date only?

i.e.

SINCE "1-Feb-1994 09:31:00 -0400"

16/08/2006, 03h52

Bob wrote:
> Is there anyway to search based on a time or is it date only?

It's date only. When I've wanted to do full date-time searches (in
various scripted applications), I've done a date search that covers the
range I want, and then fetched the INTERNALDATE of doubtful messages
and done the calculation myself for them. I suppose you could use the
SORT extension to do a binary search, but you'll still want the manual
logic for servers that don't support SORT and it'll probably only be
faster when there are a huge number of messages in the desired range.
Oh, and any performance tests to decide whether it's worthwhile will be
server specific...

Philip Guenther

11/08/2006, 21h57	#1 (permalink)
Bob Messages: n/a Hébergeur:	Search on Time Is there anyway to search based on a time or is it date only? i.e. SINCE "1-Feb-1994 09:31:00 -0400"

16/08/2006, 03h52	#2 (permalink)
Philip Guenther Messages: n/a Hébergeur:	Re: Search on Time Bob wrote: > Is there anyway to search based on a time or is it date only? It's date only. When I've wanted to do full date-time searches (in various scripted applications), I've done a date search that covers the range I want, and then fetched the INTERNALDATE of doubtful messages and done the calculation myself for them. I suppose you could use the SORT extension to do a binary search, but you'll still want the manual logic for servers that don't support SORT and it'll probably only be faster when there are a huge number of messages in the desired range. Oh, and any performance tests to decide whether it's worthwhile will be server specific... Philip Guenther

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email