[Date Prev][Date
Next][Thread Prev][Thread Next][Date
Index][Thread Index]
Re: ASP Question...
- To: <ukha_d@xxxxxxx>
- Subject: Re: ASP Question...
- From: <dorsai@xxxxxxx>
- Date: Thu, 29 Mar 2001 16:17:15 -0000
- Delivered-to: rich@xxxxxxx
- Delivered-to: mailing list ukha_d@xxxxxxx
- Mailing-list: list ukha_d@xxxxxxx; contact
ukha_d-owner@xxxxxxx
- Reply-to: ukha_d@xxxxxxx
try
SELECT mytable.date
FROM mytable
WHERE (((mytable.date)=#1:44:21#));
Cheers
Mick
andy.powell@xxxxxxx said:
> Folks,
>
> just a quickie re: ASP and Access...
>
> How do I search for records matching a TIME (i.e. The field type is
> date/time) ?? What's the SQL for it??
>
> I've tried
>
> Select * from MyTable where MYTIME='1:44:54'
>
> but this gives an ODBC error 80040e21 - ODBC Driver does not support
the
> requested properties..
>
>
> any clues???
>
> Ta muchly
>
> A.
>
>
> ************************ DISCLAIMER ************************
> This message is intended only for use by the person
> to whom it is addressed. It may contain information
> that is privileged and confidential. Its content does
> not constitute a formal commitment by Lombard Odier.
> If you are not the intended recipient of this message,
> kindly notify the sender immediately and destroy this
> message. Thank You.
> *****************************************************************
>
>
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
--
Home |
Main Index |
Thread Index
|