search

quintanar401 / connect-kdb-q

Query execution support for KDB-Q in Atom
MIT License
7 stars 5 forks source link

timespan not displaying as expected #6

Closed joel23888 closed 7 years ago

joel23888 commented 7 years ago

There seems to be a display error for timespan, see below where 0D09:34:59.000000000 should display as 0D09:35:00.000000000, which it does in another GUI (Delta Control).

update dtime:deltas `long$time from flip (enlist `time)!enlist 0D09:00 + 0D00:05 * til 8
(`SUCCESS; "kdb+ PROD1 hdb"; 5ms; 8; ([] time:`timespan$(); dtime:`long$()))
time                 dtime         
-----------------------------------
0D09:00:00.000000000 32400000000000
0D09:05:00.000000000 300000000000  
0D09:10:00.000000000 300000000000  
0D09:15:00.000000000 300000000000  
0D09:20:00.000000000 300000000000  
0D09:25:00.000000000 300000000000  
0D09:30:00.000000000 300000000000  
0D09:34:59.000000000 300000000000

Delta Control output:

1   09:00:00.000000000  32400000000000  
2   09:05:00.000000000  300000000000    
3   09:10:00.000000000  300000000000    
4   09:15:00.000000000  300000000000    
5   09:20:00.000000000  300000000000    
6   09:25:00.000000000  300000000000    
7   09:30:00.000000000  300000000000    
8   09:35:00.000000000  300000000000
quintanar401 commented 7 years ago

fixed in 0.4.3 - unnecessary division is removed