CREATE TABLE #mh4 (
 ts timestamp not null
);
go
INSERT INTO #mh4 DEFAULT VALUES;
INSERT INTO #mh4 DEFAULT VALUES;
SELECT * FROM #mh4;
/*
ts                 
------------------ 
0x00000000000003FC
0x00000000000003FD
*/
go
/*
        To convert timestamp value to numeric , use the 
        implicit conversion property of timestamp to numeric.
        The resulting value can then be converted to numeric easily.
        Please note that doing "Convert( numeric( 20, 0 ) , ts )" will
        result in the error:

Server: Msg 8114, Level 16, State 5, Line 1
Error converting data type timestamp to numeric.
*/
SELECT ts , CONVERT( numeric(20,0), ts + 0) AS Numeric_ts
FROM #mh4;
/*
ts                 Numeric_ts             
------------------ ---------------------- 
0x00000000000003FC                   1020 
0x00000000000003FD                   1021 
*/
go
DROP TABLE #mh4;
go

This page was last updated on May 01, 2006 04:28 PM.