21>
22> CREATE TABLE ConvertTest
23> (
24> ColID int IDENTITY,
25> ColTS timestamp
26> )
27> GO
1> INSERT INTO ConvertTest DEFAULT VALUES
2> GO
(1 rows affected)
1> SELECT ColTS AS "Uncoverted", CAST(ColTS AS int) AS "Converted" FROM ConvertTest
2> GO
Uncoverted
-------------------------------------------------------------------------------------
0x000000000000138A
(1 rows affected)
1> drop table convertTest;
2> GO
1>