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 <lvic4...@gmail.com> 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,