How to convert datetime to timestamp using C#/.NET (ignoring current timezone)

by

At the moment you’re calling ToUniversalTime() – just get rid of that:

private long ConvertToTimestamp(DateTime value)
{
    long epoch = (value.Ticks - 621355968000000000) / 10000000;
    return epoch;
}

Alternatively, and rather more readably IMO:

private static readonly DateTime Epoch = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc);
...

private static long ConvertToTimestamp(DateTime value)
{
    TimeSpan elapsedTime = value - Epoch;
    return (long) elapsedTime.TotalSeconds;
}

EDIT: As noted in the comments, the Kind of the DateTime you pass in isn’t taken into account when you perform subtraction. You should really pass in a value with a Kind of Utc for this to work. Unfortunately, DateTime is a bit broken in this respect – see my blog post (a rant about DateTime) for more details.

You might want to use my Noda Time date/time API instead which makes everything rather clearer, IMO.

More Related Contents:

  1. How to work with time zones in ASP.NET?
  2. Getting system Timezones in different languages
  3. Extracting div's InnerHtml?
  4. One DbContext per web request… why?
  5. Authenticate and request a user’s timeline with Twitter API 1.1 oAuth
  6. ASP.NET Identity’s default Password Hasher – How does it work and is it secure?
  7. Response.Redirect to new window
  8. Are static class instances unique to a request or a server in ASP.NET?
  9. The breakpoint will not currently be hit. No symbols have been loaded for this document in a Silverlight application
  10. Send HTML email via C# with SmtpClient
  11. Call non-static method in server-side from client-side using JavsScript
  12. How to calculate the sum of the datatable column in asp.net?
  13. Multi-select dropdown list in ASP.NET
  14. HttpWebRequest not passing Credentials
  15. What happens in BeginProcessRequest()?
  16. How to access page controls inside a static web method? [duplicate]
  17. How to restrict file type in FileUpload control
  18. Determine OS using Environment.OSVersion [duplicate]
  19. Can’t get sql server compact 3.5 / 4 to work with ASP .NET MVC 2
  20. The data source does not support server-side data paging
  21. Prevent textbox autofill with previously entered values
  22. How can I secure passwords stored inside web.config?
  23. How to change CurrentCulture at runtime?
  24. How can I determine a timezone by the UTC offset?
  25. How to return a PDF from a Web API application
  26. create local user account
  27. Database Error: There is no row at position 0
  28. How to add TemplateField programmatically
  29. WebMethod not being called
  30. LINQ to SQL Where Clause Optional Criteria

Leave a Comment