Hi,
I have a merge statement which is updating date with timestamp in a column of date data type. When I run the merge statement individually , it works fine as expected but when i run the same merge statement either in a job or inside a procedure, it updates table field only with date value without timestamp. I am clueless about the issue. Can someone help me out please?
Thanks in advace.