We are currently deploying a new user interface and navigational structure on our Community. These design changes align with our new Teradata Access portal and provide a more cohesive experience for our users.
I am curious as to what you would recommmend in this situation. I am loading a delimited flat file with a time format as the following:
Examples would be :
9:45 AM 10:25 PM
Using the Fast Load utility, is there an in built function that can convert time to be inserted into column designated as time in Teradata without complicated parsing and calculation logic? Note that if a hour is less than 10, there is no leading zero.