On Fri, 21 Jun 2013 13:45:51 +0200, "Olaf Kluge" <[email protected]> wrote: > 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? >
You need to use it as a subquery, eg (untested): SELECT FIRST 1 tmp FROM ( select cast(d_ein || ' ' || z_ein as timestamp) as tmp from t_zeitschaltuhr order by tmp ) WHERE tmp > 'now' into :tmp_next_e; Mark
