skip to main
|
skip to sidebar
.net resources
Thursday 12 August 2010
SQL Server timestamp
Getting timestamp as yyyymmddhhmmSSsss
DECLARE @sTime VARCHAR(255)
SET @sTime=REPLACE(REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR(23), GETDATE(), 121),'-',''),' ',''),':',''),'.','')
SELECT @stime
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)
Followers
Blog Archive
▼
2010
(4)
▼
August
(1)
SQL Server timestamp
►
May
(1)
►
April
(2)
►
2009
(1)
►
January
(1)
►
2008
(17)
►
October
(6)
►
May
(3)
►
March
(4)
►
January
(4)
►
2007
(46)
►
December
(4)
►
November
(5)
►
October
(20)
►
September
(17)
About Me
aslam
software professional, enjoy travelling
View my complete profile