Function that creates a timestamp in c#

c# timestamp compact-framework database-agnostic time-precision
Konstantinos picture Konstantinos · May 21, 2009 · Viewed 267.2k times · Source

I was wondering, is there a way to create a timestamp in c# from a datetime? I need a millisecond precision value that also works in Compact Framework(saying that since DateTime.ToBinary() does not exist in CF).

My problem is that i want to store this value in a database agnostic way so i can sortby it later and find out which value is greater from another etc.

Answer

RobV picture RobV · May 21, 2009

I always use something like the following:

public static String GetTimestamp(this DateTime value)
{
    return value.ToString("yyyyMMddHHmmssfff");
}

This will give you a string like 200905211035131468, as the string goes from highest order bits of the timestamp to lowest order simple string sorting in your SQL queries can be used to order by date if you're sticking values in a database

Related questions

Milliseconds in DateTime.Now on .NET Compact Framework always zero?

i want to have a time stamp for logs on a Windows Mobile project. The accuracy must be in the range a hundred milliseconds at least. However my call to DateTime.Now returns a DateTime object with the Millisecond property …

Read More
How to get the unix timestamp in C#

I have had look around stackoverflow, and even looked at some of the suggested questions and none seem to answer, how do you get a unix timestamp in C#?

Read More
How to get correct timestamp in C#

I would like to get valid timestamp in my application so I wrote: public static String GetTimestamp(DateTime value) { return value.ToString("yyyyMMddHHmmssffff"); } // ...later on in the code String timeStamp = GetTimestamp(new DateTime()); Console.WriteLine(timeStamp); output: 000101010000000000 I wanted something …

Read More