I am converting a ticks value to a date like this:
Convert(datetime, (MachineGroups.TimeAdded - 599266080000000000)/864000000000);
Using this i get:
9/27/2009 10:50:27 PM
But I want just the date in this format:
October 1, 2009
My sample ticks value is
633896886277130000
What is the best way to do this?
You can do this by formatting cell to date. Right Click on cell->Format Cell->Number tab->Date->Ok.
A single tick represents one hundred nanoseconds or one ten-millionth of a second. There are 10,000 ticks in a millisecond (see TicksPerMillisecond) and 10 million ticks in a second.
Convert text dates by using the DATEVALUE function Select a blank cell and verify that its number format is General. Click the cell that contains the text-formatted date that you want to convert. Press ENTER, and the DATEVALUE function returns the serial number of the date that is represented by the text date.
To convert a datetime to a date, you can use the CONVERT() , TRY_CONVERT() , or CAST() function.
A DateTime object can be constructed with a specific value of ticks. Once you have determined the ticks value, you can do the following:
DateTime myDate = new DateTime(numberOfTicks); String test = myDate.ToString("MMMM dd, yyyy");
It's much simpler to do this:
DateTime dt = new DateTime(633896886277130000);
Which gives
dt.ToString() ==> "9/27/2009 10:50:27 PM"
You can format this any way you want by using dt.ToString(MyFormat)
. Refer to this reference for format strings. "MMMM dd, yyyy"
works for what you specified in the question.
Not sure where you get October 1.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With