Hi @TamD ,

Basically, it's just like you've written. There is no TIME data type, so you have 2 options which you already mentioned:

-  you can use Timestamp data type and ignore its date part

-  store it as string and do conversion each time you need it