How do I isolate the 'second' component from a datetime in KDB?

Viewed 79

Let's say I have a KDB datetime. How do I isolate the 'second' part of it:

2022.02.01D14:30:12.391424612

so that would be 12?

I've tried t.second, but this brings back a time rather than integer.

2 Answers

You can do this:

q)`ss $ 2022.02.01D14:30:12.391424612
12i

you can also simply use

q)v:2022.02.01D14:30:12.391424612

q)v.ss

12i

Related