kdb+ and R

Community Support
1

Hi,

I am accessing kdb+ from R and when I access data, the time is in integers. Can anyone help me convert it to standard sate time? I tired setting system time: http://code.kx.com/wiki/Cookbook/IntegratingWithR#Connecting\_from\_R\_to\_kdb.2B\_.28a.k.a.\_Q\_Server\_for\_R.29 as given here but it didn’t work.

Thanks!

2

This is normal because kdb time is mapped to integers in r.<o:p></o:p>

<o:p> </o:p>

What you can do is to add date to time to get a timestamp.<o:p></o:p>

<o:p> </o:p>

r-code:<o:p></o:p>

<o:p> </o:p>

kdb<-open_connection(‘’,8888)<o:p></o:p>

<o:p> </o:p>

execute(kdb,’.z.t’)<o:p></o:p>

[1] 77657658                    <o:p></o:p>

<o:p> </o:p>

execute(kdb,’.z.d + .z.t’)<o:p></o:p>

[1] “2015-12-01 21:34:17 GMT”<o:p></o:p>

<o:p> </o:p>

Kim<o:p></o:p>

<o:p> </o:p>

Von: personal-kdbplus@googlegroups.com [mailto:personal-kdbplus@googlegroups.com] Im Auftrag von flabby
Gesendet: Dienstag, 1. Dezember 2015 04:30
An: Kdb+ Personal Developers
Betreff: [personal kdb+] kdb+ and R<o:p></o:p>

<o:p> </o:p>

Hi,<o:p></o:p>

<o:p> </o:p>

I am accessing kdb+ from R and when I access data, the time is in integers. Can anyone help me convert it to standard sate time? I tired setting system time: http://code.kx.com/wiki/Cookbook/IntegratingWithR#Connecting_from_R_to_kdb.2B_.28a.k.a._Q_Server_for_R.29 as given here but it didn’t work.<o:p></o:p>

<o:p> </o:p>

Thanks!<o:p></o:p>

–
Submitted via Google Groups

3

Oh I see. Thanks Kim!