SQL Server DateTime Object and C# Datetime using Entity Framework

Question

I am pretty new to Entity Framework, I was able to create a process to add new entry to a database. However the last attribute in SQL Server is a datetime type. When I fill it using from the C# application it only includes the year month and day but not the time (cf the second entry below)

newEntry.TimeStamp = DateTime.Today;

(new entry is an instance of one of the class created by Entity Framework).

enter image description here

My initial idea was to change the format using :

string sqlFormatedDate = DateTime.Today.ToString("yyyy-MM-dd HH:mm:ss");

But obviously the application does not accept the type string when I get to the line :

newEntry.TimeStamp = sqlFormatedDate;

I get the error

Cannot Implicitly convert type 'string' to 'System.DateTime?'

How can one create a datetime object in C# that will properly be displayed in SQL Server?

EDIT:

Turns out one just has to use Datetime.now

what's wrong with DateTime.Now ??

Manish Mishra
– Manish Mishra

2015-03-11 21:20:59 +00:00
Commented Mar 11, 2015 at 21:20 — Manish Mishra
– Manish Mishra, Commented Mar 11, 2015 at 21:20

christophano · Accepted Answer · 2015-03-11 21:21:28Z

2

DateTime.Today is only the Date portion of the DateTime, the time is set to midnight. I think what you need is DateTime.Now.

answered Mar 11, 2015 at 21:21

christophano

9452 gold badges21 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Giorgi Nakeuri · Accepted Answer · 2015-03-11 21:21:35Z

1

https://msdn.microsoft.com/en-us/library/system.datetime.today(v=vs.110).aspx

Property Value
Type: System.DateTime
An object that is set to today's date, with the time component set to 00:00:00.

Use DateTime.Now instead which will return date with time part.

answered Mar 11, 2015 at 21:21

Giorgi Nakeuri

35.9k8 gold badges50 silver badges78 bronze badges

1 Comment

Romain Over a year ago

Will check your answer in 10 min, when stack let me

Collectives™ on Stack Overflow

SQL Server DateTime Object and C# Datetime using Entity Framework

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related