request data from specified time

[Fred]

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

[Hugo Kornelis]

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)

[Fred]

Works like a charm. Thanks

"Hugo Kornelis" <hugo@pe_NO_rFact.in_SPAM_fo> wrote in message
news:2t********************************@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)