how insert timestamp ? in sqlcommand(.net)

Question

0.00/5 (No votes)

See more:

i try to insert to column "timestamp" a value as "Datetime.now"
but i got sql exception :

Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column.

please help

Posted 19-Aug-14 15:03pm

Member 10631195

Add a Solution

Comments

[no name] 19-Aug-14 21:09pm

Okay.... a timestamp is an auto generating value. So why are you trying to set the value of the column? Are you sure that using a timestamp is the right choice for what you are doing? What exactly are we supposed to help you with?

Member 10631195 19-Aug-14 21:13pm

i wont enter date to my table what type to use ?

Member 10631195 19-Aug-14 21:13pm

to order result by date

[no name] 19-Aug-14 21:18pm

Personally, I would use a DateTime but not knowing anything at all about your project I would have no idea what you should be using.

ChauhanAjay 19-Aug-14 21:15pm

You want to enter the into your table? If yes then create a column with datatype datetime and you can insert your date into it.

Member 10631195 19-Aug-14 21:26pm

in datetime is working but i wont like this "MM-yyyy-dd HH:mm" And the problem with this syntax is the sorting Not work well . so i think if i wont to show to users the date time
15/08/2014 not like 2014/15/08 i need to do a string function to show in my syntax
But thank you very much!

ChauhanAjay 19-Aug-14 21:35pm

Basically the date would be stored in yyyy-MM-dd HH:mm:ss in your database and you will have to use cast and convert option to change the date format in the way you like.

Reference: http://msdn.microsoft.com/en-IN/library/ms187928.aspx

Member 10631195 19-Aug-14 21:37pm

Thank you very much even if I asked a question a little funny I know

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

minhtri22 · Answer 1 · 2014-08-19T15:51:00

Just add more information about timestamp field:

Quote:
A table can have only one timestamp column. The value in the timestamp column is updated every time a row containing a timestamp column is inserted or updated. This property makes a timestamp column a poor candidate for keys, especially primary keys. Any update made to the row changes the timestamp value, thereby changing the key value. If the column is in a primary key, the old key value is no longer valid, and foreign keys referencing the old value are no longer valid. If the table is referenced in a dynamic cursor, all updates change the position of the rows in the cursor. If the column is in an index key, all updates to the data row also generate updates of the index.

Read more:
http://technet.microsoft.com/en-us/library/aa260631%28v=sql.80%29.aspx[^]

Vinay Mistry · Answer 2 · 2014-08-19T22:29:00

You can't insert the values into timestamp column explicitly. It is auto-generated. Don't use this column in your insert statement. If you want to manually manage your column then change its datatype to datetime. To know more about timestamp visit http://msdn.microsoft.com/en-us/library/ms182776(SQL.90).aspx[^]. Microsoft does not recommend using timestamp.

how insert timestamp ? in sqlcommand(.net)

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0