How to get time_column

#1

Hello everyone,
I need help
how to get hour minute and second from date_ column

Regards!
1|207x84

#2

Hello @przemek :slightly_smiling_face:

If you want to date and time from the date column, you can use the built in function for the hour function; for the minute; and for the secound; imute use the secound function.
Try it and then let me know about the result :hugs:

#3

Hi,

Use this code-

SELECT
HOUR(date_) AS hour,
MINUTE(date_) AS minute,
SECOND(date_) AS second
FROM
your_table;

Try this and let me know if it’s working

Thanks