how to convert the entire column field which is in encryted like 1263332444 of table to dd/mm/yyyy format in microsoft sql server? i got to know how to convert for a single by using [18-10-2012 20:10:25] r chinnaswamy: SELECT DATEADD(second, 1263332444, '19700101') ... i want to know how to change entire date of column..