What is Timestamp in SQL?

[Shekhar12]

Hi friends,

I am Bsc(IT) student and need your suggestion regarding the Timestamp concept of the SQL. I have read many books but still the the concept of the timestamp is not clear.

Are you able to help me to understand what is timestamp in the SQL?

Your help will be greatly appreciated..

[Praetor]

Hi Friends,

The datatype which is useful in the automatic creation of the binary numbers is called as "Timestamp". The binary number which is created by the Timestamp are must a unique number."8 bytes" is the size of the storage o the "Timestamp". A table can not include more that one column of the timestamp. When you make changes to the "Timestamp" value , the value of the keys that you have defines also get changed.

I hope this information will help you to understand the concept of the "Timestamp" of SQL.

[Katty]

Hi,

1. The method of stroring data value to the column of the date table is referred as timestamp.

2. Timestamp record in the SQL comprises data about time and date,for example rear, min, day ,month. For you information it won't be differ from standard format.

See below example:

Column---------Format

Date-----------YY-MM-DD
Time-----------HH-MM-SS
Datetime---------YY-MM-DD HH-MM-SS

[kelfro]

Hi all,

I in SQL "GETDATE() function" which is built-in is used display the current date and time in "timestamp" form.

For reference see below e.g:

USE database_demo;

select GETDATE();

The desired out-put of the above query will be:

2009-11-30 11-34-21.940

[Zecho]

The term "TIMESTAMP" is a datatype which create the unique number by using automatic process. The created number will be databse-wise unique.

For more information refer below example:

SET numCount ON

USE pus
GO

CREATE TABLE dbo.abc
(
bar INT PRIMARY KEY,
mod TIMESTAMP
)
GO


INSERT dbo.abc(bar) VALUES(1)

SELECT bar, mod FROM foo

bar mod


UPDATE dbo.abc SET bar = 1

SELECT bar, mod FROM dbo.abc

bar mod

UPDATE dbo.abc SET bar = 2