So this is (probably) the quickest way to get current time, which is useful
select current;
2020-03-17 12:28:25.000
Cheers
Paul
> Typically this is used like the Oracle construct:
>
> select 7 from dual;
> Or the Informix constructs:
>
> select 7 from sysmaster:sysdual;
> select 7 from systables where tabid = 1;
> Note that the new construct, without a FROM clause, is faster than the
> other two options in Informix. Witness these runs in sqlcmd in benchmark
> mode. I have highlighted the runtimes in RED:SQL[27]: select 7 from
> systables where tabid = 1;
> 2020-03-17 11:18:12
> + select 7 from systables where tabid = 1;
> 7
> Time: 0.002461
> SQL[28]: select 7 from sysmaster:sysdual;
> 2020-03-17 11:18:20
> + select 7 from sysmaster:sysdual;
> 7
> Time: 0.001722
> SQL[29]: select 7;
> 2020-03-17 11:18:24
> + select 7;
> 7
> Time: 0.000245
>
> Art
> Art S. Kagel, President and Principal ConsultantASK Database
> Managementwww.askdbmgt.com
#Informix