Re: time(urgent)
- From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 03 Jan 2006 23:50:26 +0100
On Thu, 29 Dec 2005 07:18:02 -0800, shif wrote:
>Hi
>How can i take time > hh:mmAM/PM and time < hh:mmAM/PM from a datetime field.
>please give me a sample query for this.
Hi shif,
I'm not sure if I understand your question. Maybe you could clarify a
bit, for instance by providing CREATE TABLE and INSERT statements and
expected output. Check out www.aspfaq.com/5006.
In the mean time, you might want to loom up CONVERT in Books Online and
see if this suits your need.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
.
- Next by Date: Re: Max of different columns
- Next by thread: Re: time(urgent)
- Index(es):
