First second of today

SQL++
1

Hi,

is there a way to get the first second of today as unixtimestamp (epoch-date)?

Thank you,

2 
select date_trunc_millis(now_millis(),'day');

https://docs.couchbase.com/server/current/n1ql/n1ql-language-reference/datefun.html#fn-date-now-millis

https://docs.couchbase.com/server/current/n1ql/n1ql-language-reference/datefun.html#fn-date-trunc-millis

HTH.