Unanswered: Creating an Interval from Datetime field
I have this field that is a varchar Finalfatetime
2006-04-07 12:16:48.373000000 (this is the output)
A DBA in our area created a function for this called fun_frmt_date that breaks it out to this 4/7/2006 12:16:48 PM
Now, I need to create an INTERVAL off the datetime field...
Someone suggested to use a CASE statement- but I do not know if that is the right choice and not sure where to start.