Re: Datetime question
"Art S. Kagel" wrote:
It DOES work! I need it in a single step because I want to create a view.
Thank you very much.
> You could try it in a single step but I'm not sure it will pass the
> parser. It would look like this:
>
> SELECT *
> FROM A, B
> WHERE (
> (extend( A.d, year to second) + {Convert d->datetime}
> (t - extend("00:00:00", hour to second))) > {Make t->interval)
> (extend( B.d, year to second ) + interval(12) hour(2) to hour)
> );>
> Art S. Kagel