Linq to SQL timestamp problem

Question

0.00/5 (No votes)

See more:

I have a SQL Table that have a timestamp field.
https://pasteboard.co/JOFlRZh.png[^]
When i insert as new record to table (without time value) then inserting a time as "00:00:00".
https://pasteboard.co/JOFmoku.png[^]
What can i do for that?
Thanks.

What I have tried:

I have no idea. (This area must have more than 30 characters.)

Posted 16-Feb-21 9:07am

gacar

Updated 16-Feb-21 9:25am

Add a Solution

Comments

Richard MacCutchan 16-Feb-21 15:09pm

What value would you expect to get from a zero time value?

gacar 16-Feb-21 15:13pm

Time at recording time

Richard MacCutchan 16-Feb-21 15:20pm

Then you need to add some code to set the item to the required time.

gacar 16-Feb-21 15:24pm

Why? It is not necessary. If so why using timestamp?

Richard Deeming 17-Feb-21 6:46am

The default value only applies if no value is specified when the record is inserted.

When you insert a record using Linq2Sql, it will specify a value for all columns that it knows about. If you haven't set a value for the property in your code, then the property value will be 00:00:00. That is the value which L2S will insert into the table, which means SQL Server will ignore the default constraint on the column.

gacar 20-Feb-21 18:31pm

This is very clever, I tried it but it still didn't work. The values went as Null.

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)

RickZeeland · Answer 1 · 2021-02-16T09:23:00

Solution 1

Assuming you are using SQL Server, you can set the current date and time as in the example here: SQL DEFAULT Constraint[^]

OrderDate date DEFAULT GETDATE()

Posted 16-Feb-21 9:23am

RickZeeland

Comments

gacar 16-Feb-21 15:40pm

Thank you for solution. I tired this but still inserting time as "00:00:00"

RickZeeland 16-Feb-21 15:44pm

Then take a look at the answer by OriginalGriff, he suggests to pass a null value for the column, that should do the trick (don't know if this will work in Linq to SQL however)

gacar 16-Feb-21 15:49pm

I already sending null value to SQL via linq. My problem this isue already. Don't fill time value auto by SQL

OriginalGriff · Answer 2 · 2021-02-16T09:25:00

Solution 2

The easiest way is to set the default value for the column to GETDATE() and pass a null value for the column.

SQL will then put the current date and time into the field for you.

Posted 16-Feb-21 9:25am

OriginalGriff

Comments

gacar 16-Feb-21 15:42pm

Yes right, it must be so, but don't filling current time by SQL.