How to efficiently query all records of timestamp.second == 5 in the orderbook table

user_15526999 0
Viewed 26

How can I efficiently query all the records of timestamp.second == 5 in the orderbook table in dolphindb? For example, the records of timestamp 00:00:05, 00:01:05 00:02:05.  can the following statement work? select * from tick where timestamp.second == 5? 

dolphindb time-series timestamp
1 Answers

There is a "secondOfMinute" to get the number of seconds, such as:

select * from tick where secondOfMinute(timestamp) == 5   
user_167486660
Related