Unable to update the datetime column - MSDN - Microsoft

UPDATE COMMS SET TX_DATETIME='23/04/2012' WHERE ID = '18928' ... The reason why SQL Server doesn't like your datetime value is because .... 1) I was logged into MS SQL Studio Manager as a Windows user rather ...

social.msdn.microsoft.com