Hi,
I using the following query
select dateadd(s, 1185255439727, '01-01-1970 05:30:00')
on MSSQL 2005. I get the error
Arithmetic overflow error converting expression to data type int.
If I use the query
select dateadd(ss, 1088728808 , '01-01-1970 05:30:00') I dont get this error. Looks big numbers are having problem. Please help
2  12637  ck9663 2,878
Recognized Expert Specialist
Hi,
I using the following query
select dateadd(s, 1185255439727, '01-01-1970 05:30:00')
on MSSQL 2005. I get the error
Arithmetic overflow error converting expression to data type int.
If I use the query
select dateadd(ss, 1088728808 , '01-01-1970 05:30:00') I dont get this error. Looks big numbers are having problem. Please help
maybe you should consider adding year instead of seconds on your date...that's a lot of seconds
I would take the number of seconds, divide it out;
There are 31536000 Seconds in a year so store that value in a variable as 1 or 2, ect depending upon how many years you have.
Subtract 31536000 * (the value stored from above) from your starting value to get the remaining time. Then do the same for days, then minutes, then seconds.
Do not do this for months as each month has varying number of days.
This way you will date add to Year, Days, Minutes, Seconds.
This will be more manageable.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: shank |
last post by:
I got the following error: Arithmetic overflow error converting numeric to
data type numeric
I'm sure it was one of my currency fields. However, the real total of that
column was $776.92
How did it get submitted as $776.9200000000001 ?
Is there a way I can assure those extra digits get whacked?
thanks!
|
by: MOvetsky |
last post by:
Is the following code ISO C++ standard compliant?
If yes, is it guaranteed that it will not crash on compliant platforms?
If yes, will it print "Pointers are equal" on any compliant platform?
Will answers be the same if p points to local memory or string literal?
char *p = new char;
char *p1 = p-1;
p1 = p1 + 1;
|
by: TTroy |
last post by:
Hello, I'm relatively new to C and have gone through more than 4 books
on it. None mentioned anything about integral promotion, arithmetic
conversion, value preserving and unsigned preserving. And K&R2
mentions "signed extension" everywhere.
Reading some old clc posts, I've beginning to realize that these books
are over-generalizing the...
|
by: houstorx |
last post by:
I've been looking at the committee draft of the C99 specification,
specifically the one at this URI:
http://www.open-std.org/jtc1/sc22/wg14/www/docs/n843.pdf. I don't have
a copy of the official international standard, but I assume that it is
similar.
The rules for pointer arithmetic (6.5.6.7-8) are appended below for
ease of reference....
|
by: Saso Zagoranski |
last post by:
Hi!
I have created an SqlCommand object and I have set some parameters to it...
One of the parameters is of the DateTime type;
here is the code:
sqlCommand.Parameters.Value = DateTime.Parse(this.DateTextBox.Text);
sqlCommand.ExecuteNonReader();
I get the error:
| | |
by: Bill Reid |
last post by:
Bear with me, as I am not a "professional" programmer, but I was
working on part of program that reads parts of four text files into
a buffer which I re-allocate the size as I read each file. I read some
of the items from the bottom up of the buffer, and some from the
top down, moving the bottom items back to the new re-allocated
bottom on...
|
by: Frederick Gotham |
last post by:
There is a thread currently active on this newsgroup entitled:
"how to calculate the difference between 2 addresses ?"
The thread deals with calculating the distance, in bytes, between two
memory addresses. Obviously, this can only be done if the addresses refer
to elements or members of the same object (or base objects, etc.).
John...
|
by: darrel |
last post by:
I'm getting this error:
Arithmetic overflow error converting numeric to data type numeric.
Triggered on this line of my code:
objOleDbAdapter.Fill(DS, "rss")
Everything works when this is pointed at one DB server (our staging server)
but when we point it at another DB server (our production server) I get the
error.
|
by: sonata |
last post by:
I am trying to compare two fields which are char data typr.
BUT the comparision must be arithemetic in nature.
so i tried to cast both the data base field and my parameter field to big int types which failed.
I tried for Decimal type conversion and then comparision.
It gave me the above error.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
