How to use TIMESTAMP

Hi ,
Can i know how to use timestamp ?
i am using SQL ver 7.0 and i have set a column as
timestamp type
First of all , is timestamp used to captured the
date/time that the row has been modified '
scenario :
i would like a column to be capturing the date/time a
row has been last modified
using my select query how do i select the rows that is
updated on that particular day using the timestamp as it's
stored as binary
thks & rdgsTimestamp is NOT a date/time representation. It is only used to
automatically update when a row is inserted/updated. If you want to capture
when a row was modified add a datetime column and update it to GetDate() in
an insert/update trigger. You could put in the user using suser_sname() into
a varchar column at the same time if you were interested.
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:114101c47b6d$06a73690$a501280a@.phx.gbl...
> Hi ,
> Can i know how to use timestamp ?
> i am using SQL ver 7.0 and i have set a column as
> timestamp type
> First of all , is timestamp used to captured the
> date/time that the row has been modified '
> scenario :
> i would like a column to be capturing the date/time a
> row has been last modified
> using my select query how do i select the rows that is
> updated on that particular day using the timestamp as it's
> stored as binary
> thks & rdgs|||Hi Mary ,
thks for ur explanation =)
rdgs
>--Original Message--
>Timestamp is NOT a date/time representation. It is only
used to
>automatically update when a row is inserted/updated. If
you want to capture
>when a row was modified add a datetime column and update
it to GetDate() in
>an insert/update trigger. You could put in the user using
suser_sname() into
>a varchar column at the same time if you were interested.
>"maxzsim" <anonymous@.discussions.microsoft.com> wrote in
message
>news:114101c47b6d$06a73690$a501280a@.phx.gbl...
>> Hi ,
>> Can i know how to use timestamp ?
>> i am using SQL ver 7.0 and i have set a column as
>> timestamp type
>> First of all , is timestamp used to captured the
>> date/time that the row has been modified '
>> scenario :
>> i would like a column to be capturing the date/time a
>> row has been last modified
>> using my select query how do i select the rows that is
>> updated on that particular day using the timestamp as
it's
>> stored as binary
>> thks & rdgs
>
>.
>