0 - 2 of 2 tags for mssql

Using MSSQL 2000. I have a table with duplicate rows that needs to be updated. I have new values with similar table.
Table A:
UID        Type
11796     30
11796     31
11796     48
11556     302
11556     305
11552     146
 
Table B:
UID        Type
11796     50

Hello, does anyone know of an equivalent for the MSSQL data type DATETIME? I cannot seem to find anything in Teradata documentation that indicates such. Using TIMESTAMP is not an option as it is a HEX type.

Thanks