All Forums Database
urskumar 6 posts Joined 08/07
19 Aug 2016
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)
 
 

kumar
bhavesh_09 3 posts Joined 06/12
22 Aug 2016

try this:
 

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

 

urskumar 6 posts Joined 08/07
22 Aug 2016

Thank you bhavesh its working fine :)

kumar

You must sign in to leave a comment.