here is the script from my colleague if u want to convert DATETIME data type to SMALLDATETIME because simple CONVERT is not working SELECT CONVERT (SMALLDATETIME, CONVERT (VARCHAR, GETDATE(), 103), 103) until then
this is my personal web blog..anything that i do each day hopefully can get in this blog since i only able to write it if i have spare time at the office..(ky g kerja aj ya hahaa)