request data from specified time

#1 (**permalink**) 02-29-2008, 04:15 AM

I have a table (Tickdata; Contract,Price,Timecreated) which stores
Timecreated as datetime. I need to request the maximum price where the
Timecreated is greater than some value, in this case 9/13/2004 3:09:29 PM.

How exactly do I get data from a specified time?

Thanks

#2 (**permalink**) 02-29-2008, 04:15 AM

On Mon, 13 Sep 2004 16:05:36 +1000, Fred wrote:

>I have a table (Tickdata; Contract,Price,Timecreated) which stores
>Timecreated as datetime. I need to request the maximum price where the
>Timecreated is greater than some value, in this case 9/13/2004 3:09:29 PM.
>
>How exactly do I get data from a specified time?
>
>Thanks

Hi Fred,

SELECT MAX(Price)
FROM TickDate
WHERE Timecreated > '2004-09-13T15:09:29'

?

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

#3 (**permalink**) 02-29-2008, 04:16 AM

Works like a charm. Thanks

"Hugo Kornelis" <hugo@pe_NO_rFact.in_SPAM_fo> wrote in message
news:2toak01nidr0q0d8bqhahn4oa21lbkh1kn@4ax.com...
> On Mon, 13 Sep 2004 16:05:36 +1000, Fred wrote:
>
> >I have a table (Tickdata; Contract,Price,Timecreated) which stores
> >Timecreated as datetime. I need to request the maximum price where the
> >Timecreated is greater than some value, in this case 9/13/2004 3:09:29
PM.
> >
> >How exactly do I get data from a specified time?
> >
> >Thanks
>
> Hi Fred,
>
> SELECT MAX(Price)
> FROM TickDate
> WHERE Timecreated > '2004-09-13T15:09:29'
>
> ?
>
> Best, Hugo
> --
>
> (Remove _NO_ and _SPAM_ to get my e-mail address)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode