Geeks Talk

Prepare for your Next Interview




time stamp

This is a discussion on time stamp within the SQL Server forums, part of the Databases category; can anybody plz explain about timestamp in sqlserver...


Go Back   Geeks Talk > Databases > SQL Server

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 02-09-2008
Junior Member
 
Join Date: Feb 2008
Location: bangalore
Posts: 18
Thanks: 0
Thanked 2 Times in 1 Post
venkat.rbs is on a distinguished road
time stamp

can anybody plz explain about timestamp in sqlserver
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 02-11-2008
Moderator
 
Join Date: Jun 2007
Location: Bangalore,India
Posts: 1,432
Thanks: 8
Thanked 125 Times in 112 Posts
debasisdas will become famous soon enoughdebasisdas will become famous soon enough
Re: time stamp

Please find the details here and here.
Reply With Quote
  #3 (permalink)  
Old 02-12-2008
Contributing Member
 
Join Date: Jun 2007
Location: Delhi, India
Posts: 50
Thanks: 0
Thanked 22 Times in 18 Posts
vikasvaidya is on a distinguished road
Re: time stamp

The SQL Server timestamp data type has nothing to do with times or dates. SQL Server timestamps are binary numbers that indicate the relative sequence in which data modifications took place in a database. The timestamp data type was originally implemented to support the SQL Server recovery algorithms.


----V V----
Regards,
Vikas Vaidya
Reply With Quote
  #4 (permalink)  
Old 02-12-2008
Junior Member
 
Join Date: Feb 2008
Location: bangalore
Posts: 18
Thanks: 0
Thanked 2 Times in 1 Post
venkat.rbs is on a distinguished road
Re: time stamp

Quote:
Originally Posted by vikasvaidya View Post
The SQL Server timestamp data type has nothing to do with times or dates. SQL Server timestamps are binary numbers that indicate the relative sequence in which data modifications took place in a database. The timestamp data type was originally implemented to support the SQL Server recovery algorithms.


----V V----
Regards,
Vikas Vaidya
Thanks allot Vaidya
Reply With Quote
Reply

  Geeks Talk > Databases > SQL Server


Thread Tools
Display Modes


Similar Threads

Thread Thread Starter Forum Replies Last Post
what is the difference between Wait time and Think time? mantra LoadRunner 8 09-18-2007 03:26 AM
Easy Time Tracking is a powerful, yet extremely easy-to-use time management and custo JobHelper Geeks Lounge 0 09-12-2007 02:52 PM
C++ compile time errors vs link time errors benyao C and C++ 1 06-29-2007 04:08 AM
Completed My Diploma as Full time and BE Degree as Part time Geek_Guest Career Advice 0 05-21-2007 05:02 PM
How to set time fred PHP 1 11-12-2006 03:20 PM


All times are GMT -4. The time now is 07:52 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved