Getting a timestamp for today at midnight?

[l vic]

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,