wint100
asked on
Convert Data in Table from float to Integer
RecordNumber TLInstance Timestamp Hundredths Type Data Flags
139543 101 2013-01-17 09:15:00.000 4 0 1.91663e+006 0
139544 101 2013-01-17 09:30:01.000 52 0 1.91673e+006 0
139545 101 2013-01-17 09:45:00.000 11 0 1.91682e+006 0
139546 101 2013-01-17 10:00:01.000 49 0 1.91692e+006 0
139547 101 2013-01-17 10:15:00.000 20 0 1.91701e+006 0
139548 101 2013-01-17 10:30:01.000 69 0 1.91709e+006 0
139549 101 2013-01-17 10:45:00.000 12 0 1.91718e+006 0
139550 101 2013-01-17 11:00:01.000 53 0 1.91727e+006 0
139551 101 2013-01-17 11:00:01.000 53 1 259::42 0
139552 101 2013-01-17 11:06:01.000 70 3 11 0
139553 101 2013-01-17 11:06:01.000 70 3 00 0
139554 101 2013-01-17 11:15:00.000 0 0 1917363 0
139555 101 2013-01-17 11:30:00.000 0 0 1917455 0
139556 101 2013-01-17 11:45:00.000 0 0 1917548 0
139557 101 2013-01-17 12:00:00.000 0 0 1917641 0
139558 101 2013-01-17 12:15:00.000 0 0 1917735 0
139559 101 2013-01-17 12:30:00.000 0 0 1917831 0
Hi,I have a application archiving data every 15mins into a database. I've recently changed the datatype of the data going into the table (the table column is still a Varchar(32)), but now need to convert the Historic data to an integer.
to better display my requirement, I've attached a sample of the old and new data. I could really use an update query to go through all of the rows, and convert from the old to new datatype, so that is displays correctly in the application. Currently, the application on displays a 1 when the Data is recorded as 1.91663e+006. I need to convert this 1.91663e+006 to its actual value of 1916630.
Any help is appreciated.
ASKER
Can this be used to update all historic data (2 years of samples recorded @ 15min intervals) on table called Data? I need it to update all rows in the table.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window