On 26 Aug 2005 at 4:40, ra8009 wrote:

>If I use the TimeStamp field type, can I query for just the date or
>just the time?

Yes. Cast the field as date or time respectively.

> Does storing the date and time seperately have an
>advantage?

If you often query for just time and want the query to use index -
yes.

--
SY, Dimitry Sibiryakov.