DateTime.Now.Ticks verse DateTime in web forms app

Question

User-1188570427 posted

I am sending emails based on a certain DateTime.

I need to save that DateTime in my database in a notification table in some form.

The email might not go out exactly at that DateTime specified, but is it better to save the actual DateTime value in the database or can I save the .Tick value as a string in the database and query off of that?

Thanks.

Answer 1

User753101303 posted

Hi,

Not sure to see which benefit you see in using Ticks. It seems enough and easier to just use DateTime.Now or UtcNow and store them as datetimes ? Or you try to use this as a kind of "identifier" ? You have a Message-ID header but I never tried to see if it could be provided from the SMTP client side rather than being assigned by the mail server.

Answer 2

User-1716253493 posted

Save the data as datetime value, if you need tick value see below

http://michaeljswart.com/2017/07/converting-from-datetime-to-ticks-using-sql-server/

Answer 3

User-1188570427 posted

Hi,

Not sure to see which benefit you see in using Ticks. It seems enough and easier to just use DateTime.Now or UtcNow and store them as datetimes ? Or you try to use this as a kind of "identifier" ? You have a Message-ID header but I never tried to see if it could be provided from the SMTP client side rather than being assigned by the mail server.

Thank you for your opinion!

Answer 4

User-1188570427 posted

Save the data as datetime value, if you need tick value see below

http://michaeljswart.com/2017/07/converting-from-datetime-to-ticks-using-sql-server/

Thank you for your opinion!