Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wawansur
Starting Member
44 Posts |
 Posted - 2009-09-03 : 23:53:55
|
| I have table which have coulumn with name FSeqTimeThe data type for this coulumn is timestampI convert that data type like this.select FSeqTime from stckmskselect convert(numeric(20,0), FSeqTime + 0) from stckmskFSeqtime0x000000000003837D0x00000000000384760x00000000000384BA0x00000000000384BE0x00000000000384CEselect convert(numeric(20,0), FSeqTime + 0) from stckmsk230269230518230586230590230606how to convert back that data so i get result like firstI'm nothing just gonna being |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-09-04 : 00:52:52
|
| try like thisselect cast((230269) as timestamp)select convert(timestamp ,(230269)) |
 |
|
|
wawansur
Starting Member
44 Posts |
Posted - 2009-09-04 : 02:13:55
|
| thx broRgds,WawanI'm nothing just gonna being |
|
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-09-04 : 03:47:09
|
| welcome |
|
|
|
|
|
|
How to convert bigint into timestamp ?