CAST TIME(0) to INTERVAL HOUR TO SECOND

Database
Enthusiast

CAST TIME(0) to INTERVAL HOUR TO SECOND

Hi,

Can you pleae help to CAST a TIME(0) data type to INTERVAL HOUR TO SECOND.

Regards,
Koushik
1 REPLY
Enthusiast

Re: CAST TIME(0) to INTERVAL HOUR TO SECOND

I hope below SQL should work for you

SEL (CURRENT_TIME(0) - TIME '00:00:00') HOUR TO SECOND(0)