Solved

# Convert integer to datetime and back again

Posted on 2014-02-10
212 Views
I would like to convert 28 to 28days in date time format (i.e. 28:00:00:00.0000000).

The reason is i have a timespan and i need to divide it by an integer and check if the result is a whole number.

0
Question by:SweetingA

LVL 19

Expert Comment

Something like this:

``````DateTime firstOfTheMonth = new DateTime(2014, 2, 1);
DateTime twentyEighthOfTheMonth = new DateTime(2014, 2, 28);

TimeSpan twentyEightDays = new TimeSpan(twentyEighthOfTheMonth.ticks - firstOfTheMonth.ticks);
``````

I think that will work. Maybe usee 2014, 2, 29 for a full 28-days later?
0

LVL 3

Expert Comment

here is how to add days to a date
look and yoru see for months and years also
WHERE (DateAdd(Day, Datediff(Day,0, OnlinePayments.orderdate), 0) = @startdate) AND
if you looking for leap year
there  alot of code out there to test

hope this helps not sure if its what you want
0

Author Comment

Sorry i don;t think i have explained myself too well.

a = 32:10:12:07.000000 (32days / 10hrs / 12 mins / 7 secs / 0 milli seconds) its a datetime
b = 28 its an integer

i need to divide a by b and then check if the number is a whole number, the problem at the moment is i have two different types datetime + integer and one will not divide by the other
0

LVL 40

Expert Comment

If you are only interested in the day part, then the following will do it:

a.Day / b
0

Author Comment

That would work is the difference between my two dates is always displayed in days, if that possible?
0

Author Comment

Actually it works well but how do i get the answer as a decimal?
0

LVL 10

Expert Comment

This ensures that the solution is a decimal to.

so 3 days divided by integer 2 is 1
and 3 days divided by decimal 2 is 1.5

hope to have helped
0

LVL 40

Accepted Solution

Jacques Bourgeois (James Burger) earned 500 total points
a.Day / b - cint(a.Day / b)
0

## Featured Post

### Suggested Solutions

IP addresses can be stored in a database in any of several ways.  These ways may vary based on the volume of the data.  I was dealing with quite a large amount of data for user authentication purpose, and needed a way to minimize the storage.   …
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This video discusses moving either the default database or any database to a new volume.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…