Retrieving time from database

[tomp93]

I wanted to retrieve a data from database which is in time format. But in labview along with time it is showing system date. 

What should be done to retrieve only time from database.

Labview version:2018

Database: MySQL 8.0 

[Artem.SPb]

What format does the column have in the database?
How do you read these data?

[tomp93]

In database its having time format. I used DB Tools Select All Data API for retrieving data. 

[Artem.SPb]

I don't have "select all" vi in my list. Only "select data" (may be another version) . It returns Variant, not string.
Show your string. And what do you need to get insteead of it?
May be you just need convert it into timestamp and take only time part.