Couchbase Forums

First second of today

flaviu February 4, 2022, 1:25am 1

Hi,

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

Thank you,

dh February 4, 2022, 9:43am 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.