可以datetime(ts)+60或datetimeAdd(ts,1,"m"):
select top 1 datetime(datetimeAdd(ts,1,'m')) as DT,code as Code,open as Open ,High as High,low as Low,close as Close , volume as Volume from tb_ohlc
DT类型是datetime ，如何调整让他+1分钟
請教一下，在DolphinDB database中，DT型態是datetime 我如何調整讓他+1分鐘？
下圖是我用 datetime(ts) + minute(1) 的結果
select top 1 datetime(dateime(ts)+minute(1)) as DT,code as Code,open as Open ,High as High,low as Low,close as Close , volume as Volume from tb_ohlc
跟預期不一樣,變成只多一秒。