how would we update colomn of date datatype,in which format we would write date?

Answer 1

update Table
SET Date = '18.12.2016'
WHERE id = 5

Or '18-12-2016'
Maybe u have another date format