I've two databases. There are common Tables between them. In DB1, the datatime column are NOT in UTC fomat. The same tables in DB2 are in UTC format. I would like to ensure that ALL the DATATIME columns are in UTC fomat. Meaning that NONE of the DATETIME column value should be equal between DB1 and DB2 for the common tables.
How to achieve this? Please do assist.