Viewing 3 posts - 1 through 3 (of 3 total)
Raw data looks like as it shows in Terminate_date column, My mission is to show only employees who were terminated within 30 days
EMPSTATUS - ...
November 7, 2007 at 3:13 pm
The datatype of terminate_date is decimal and I convert that to datetime and show as status_date so that I would be able to achieve my requirement but it gives me...
November 7, 2007 at 3:02 pm
Since I'm also converting the status_date into date format from numeric, it throws the error
"Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type...
November 7, 2007 at 2:42 pm
Viewing 3 posts - 1 through 3 (of 3 total)