I’m trying to add a new column using the Derived Column transformation; I need to accomplish the following but not having any luck:
Need to substract 1 ½ day from Current time.
This is what I have:
GETDATE() – 1.5
This is not working, I know I have to use a cast operator but can’t figure out which one.