Solved

Convert integer to datetime and back again

Posted on 2014-02-10
8
212 Views
Last Modified: 2014-02-11
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.

Thanks in advance
0
Comment
Question by:SweetingA
8 Comments
 
LVL 19

Expert Comment

by:Daniel Van Der Werken
Comment Utility
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);

Open in new window


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

Expert Comment

by:john M
Comment Utility
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

by:SweetingA
Comment Utility
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

by:Jacques Bourgeois (James Burger)
Comment Utility
If you are only interested in the day part, then the following will do it:

a.Day / b
0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 

Author Comment

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

Author Comment

by:SweetingA
Comment Utility
Actually it works well but how do i get the answer as a decimal?
0
 
LVL 10

Expert Comment

by:John Claes
Comment Utility
you can make b a decimal to start with;
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

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

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

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…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now