I have 3 fields fields:

Fieldname        Type
LastUsedDate  Date
LastUsedTime  TIME
MinutesLeft       Integer


I would like a query to get me the expiration datetime using the =
follwoing formula:
ExpirationDatetime =3D LastUsedDate+LastUsedTime+MinutesLeft
I want The ExpirationDatetime to be a timestamp field.

I can't figure out how to add minutes to a time field then concatenate =
the result with a date field to obtain a timestamp.

Thank you,
-Halim

Halim
>I have 3 fields fields:

>Fieldname        Type
>LastUsedDate  Date
>LastUsedTime  TIME
>MinutesLeft       Integer


>I would like a query to get me the expiration datetime using the follwoing
formula:
>ExpirationDatetime = LastUsedDate+LastUsedTime+MinutesLeft
>I want The ExpirationDatetime to be a timestamp field.

How about

SELECT CAST(CAST(LastUsedDate AS CHAR(10))+' '+CAST(LastUsedTime AS CHAR(8))
AS TIMESTAMP)+(MinutesLeft*60000) FROM Table

John

I like it.
Thank you John,
-Halim
"John Hay" <j.haywithoutdot@crbsolutionsremoveallthis.co.uk> wrote in
message news:A9308167-2BCF-4340-902B-180CC5726603@news.elevatesoft.com...
> Halim
>>I have 3 fields fields:
>
>>Fieldname        Type
>>LastUsedDate  Date
>>LastUsedTime  TIME
>>MinutesLeft       Integer
>
>
>>I would like a query to get me the expiration datetime using the follwoing
> formula:
>>ExpirationDatetime = LastUsedDate+LastUsedTime+MinutesLeft
>>I want The ExpirationDatetime to be a timestamp field.
>
> How about
>
> SELECT CAST(CAST(LastUsedDate AS CHAR(10))+' '+CAST(LastUsedTime AS
> CHAR(8))
> AS TIMESTAMP)+(MinutesLeft*60000) FROM Table
>
> John
>
>
>