How to convert the varchar to time(6) In Teradata?

Database
Enthusiast

How to convert the varchar to time(6) In Teradata?

Hi Experts

I have time value in the source with the datatype varchar(100), Need to conver this to time(6).

values with the varchar 11:30, 12:30: 01.00 like this...Need to convert these values to Time(6)

2 REPLIES

Re: How to convert the varchar to time(6) In Teradata?

try this:

select cast ('11:30'||':00.00' as time(6))
Enthusiast

Re: How to convert the varchar to time(6) In Teradata?

Thank you bhavesh its working fine :)