DateTime.Now

Question

User895691971 posted

Hi, 

I am not able to understand why time stamp used in one block of code doesnotmatch the other, even the variable used is same.

In this picture you can see the comment was made just after a few minutes, but the TimeStamp is saved in a different manner, I was told about Culture, but thats not being used anywhere. 

Everywhere, if the comment is on post then the timestamp is like this but on photos the timestamp is just like the one in the post.

The variable is same used: 

var time = DateTime.Now;

In the post and photo.

Answer 1

User895691971 posted

Hehehe just found one error, the data type was set to nvarchar in the comment So it was being saved like that.

Answer 2

User-1426144113 posted

Hi,

I would like to know why the type of nvarchar will effect the data. Could you provide the detail reason?

Thanks

Answer 3

User895691971 posted

Hi, actually the code 

DateTime.Now;

gets the current time of the computer, and after you submit, it is saved based on the datatype of the Column. It was saved as that because it was allowing 'Sep' in other column it was DateTime so it had to convert the 'Sep' to '9'.

Answer 4

User895691971 posted

Hi, actually the code 

DateTime.Now;

gets the current time of the computer, and after you submit, it is saved based on the datatype of the Column. It was saved as that because it was allowing 'Sep' in other column it was DateTime so it had to convert the 'Sep' to '9'.