sorry, you meant the alias tmp. I have misunderstood that.
Am 21.06.2013, 13:54 Uhr, schrieb Vitali Voroth <vitvoroth-...@yahoo.de>:
> wher tmp > cast('now' as timestamp) ?
>
> Am 21.06.2013, 13:45 Uhr, schrieb Olaf Kluge <olaf.kl...@satron.de>:
>
>> Hello,
>>
>>
>> I did the following:
>>
>>
>> select first 1 cast(d_ein || ' ' || z_ein as timestamp) as tmp from
>> t_zeitschaltuhr order by tmp into :tmp_next_e;
>>
>> select first 1 cast(d_aus || ' ' || z_aus as timestamp) as tmp from
>> t_zeitschaltuhr order by tmp into :tmp_next_a;
>>
>>
>> d_ein is a date, z_ein a time, I would like a timestamp and get the next
>> after now. (Time to switch the machine next time off and on:
>>
>>
>> This time should be the next in the future, so I thought: where tmp >
>> 'now'
>> , but I can't use the alias for the condition. What can I do?
>>
>>
>> Thanks a lot.
>>
>>
>> Best regards.
>>
>>
>>
>> Olaf
>>
>>
>>
>>
>>
>> [Non-text portions of this message have been removed]
>>
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
firebird-support-dig...@yahoogroups.com
firebird-support-fullfeatu...@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
