All Forums Tools
nccoyle 1 post Joined 03/06
03 Mar 2006
Time Convert in Fast load - AM / PM

Hello,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:HH:MM PM/AMExamples would be :9:45 AM10:25 PMUsing 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.Thanks!

You must sign in to leave a comment.