KX Community

Hi all,suppose,q)t:(92510111i,102510111i)I want to convert t into time types.but it is wrong,convert "92510111" into time types.How do i get 09:25:10.111 10:25:10.111?Can you help me?Thanks,Sky

Hi All,Suppose:Header message:records types byte------------------1000 11 368My question:How I should be in accordance with the specific byte aligned (8 bytes or others), convert KDB + data into binary?Have a good week!Thanks,Sky

Hi,suppose,q)t:("ihhj*";4 2 2 8 9)1:(`:/f.bin;8;25)q)19423113680 "\000\ 000\000\000\ 000\000\000\ 000\000"q)tb:flip `c1`c2`c3`c4`c5!tHow to convert type of string into a date type in table tb?Best Regards,Sky

Hi, suppose: q)dir1:`:/test; q)key dir1 `20141201`20141202`.... q)dir2:` sv dir,(key dir1) 0 q)key dir2 `IBM.txt`AMD.txt`.... I should how to iterate through all the text files and generate partition hdb? Best regards, Sky.

Hi All, Sometimes exchange trading hours ahead of a small, leading to more some of the bars.for example：q)tradesym time price sizeIBM 09:24:57 20.30 100IBM 09:30:00 20.31 150 q)t:select last price，sum size by sym,1 xbar time.minute from tradeq)tsym t...