Hello I have a very basic timestamp question. There is a data type in SQl Servertimestamp.
what I basically want is that when someone Inserts a data the timestamp column puts a timestamp there...how can i achieve that?...I thought that the timestamp type automatically does that
Yes you cannot insert into a timestamp column. SQL Server does that for you.
|||If it puts a time stamp then instead of seeing some date when I open the table and look under the timestamp column I see something like: 0x00000000E4EBF66E
what does that mean? why it is not putting date there?
|||Thats the hex value of the date/time value. Its very specific. I forget what measure of time it measures to, but its very specific.
Tim
|||
sahajMarg:
If it puts a time stamp then instead of seeing some date when I open the table and look under the timestamp column I see something like: 0x00000000E4EBF66E
what does that mean? why it is not putting date there?
Yes its a binary number assigned by SQL Server. you should read up books online for timestamp columns to understand where/how it can be used.
|||
sahajMarg:
If it puts a time stamp then instead of seeing some date when I open the table and look under the timestamp column I see something like: 0x00000000E4EBF66E
what does that mean? why it is not putting date there?
Yes its a binary number assigned by SQL Server. you should read up books online for timestamp columns to understand where/how it can be used.
||| Just read it the same post the it is the Hex value of date and time..is that correct?
没有评论:
发表评论