You should be able to do something like:
${now():divide( 86400000 ):multiply( 86400000)}
I.e., use integer division to divide by number of milliseconds in a day, which
gives you
the number of days since epoch. Then multiply by 86,400,000 again to convert
from
days back to milliseconds. While it looks immediately like it would do nothing,
the thing
to keep in mind is that the divide() function performs and Integer Division
operation,
not a Decimal Division, so all decimals would be dropped, which essentially
results in
all hours/mins/seconds/milliseconds getting dropped.
Thanks
-Mark
> On Nov 14, 2018, at 9:01 AM, l vic <[email protected]> wrote:
>
> I have to retrieve "today's" records in ExecuteSQL, eg. with the query using
> timestamp "ts" column in table where ts type is "epoch" time as long integer :
> select * from mytable where ts >= midnight-timestamp-value
> Any idea how i can use "now()" function to get today's timestamp value at
> midnight?
> Thank you,
