Time Convert in Fast load - AM / PM

Tools & Utilities

Time Convert in Fast load - AM / PM


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.