search

jshinonome / vscode-q

vscode kdb+/q extension
GNU General Public License v3.0
41 stars 16 forks source link

Negative times/timestamps are displayed mod 24h in grid view #76

Closed travis-leith closed 2 years ago

travis-leith commented 2 years ago 
select from ([]utcOffset:enlist -04:00:00.0)
exec utcOffset from ([]utcOffset:enlist -04:00:00.0)
jshinonome commented 2 years ago

It is awkward that Javascript doesn't have a proper way to store negative time. You see minus time in a dictionary is because it is casted to string.

jshinonome commented 2 years ago

@travis-leith I would recommend you to string the time column in the query. I have no easy way to deal with this issue.