
July 22nd, 2002, 09:08 AM
|
|
Contributing User
|
|
Join Date: Dec 2002
Posts: 14,575
  
Time spent in forums: < 1 sec
Reputation Power: 22
|
|
|
Using DataFormatString or???
<i><b>Originally posted by : BombKlan (d98ost@du.se)</b></i><br />Does anybody knows if I can divide a string by using DataFormatString?<br />This is my problem.<br />I need to divide the outputs from my SQL query by 60 to get a correct result.<br /><br />or...maybe I should do this operation in the query it self?<br /><br />I'm kinda novice at this but my query looks like this<br /><br />("SELECT Starttime, Stoptime from timetable", myConnection)<br /><br />The output from Starttime and Stoptime generate x minutes after midnight so I need to divide em by 60 to get a correct stroke of the clock.<br /><br />ie. Starttime generates 10.00 instead of 600 and Stoptime generates 12.00 instead of 720!!!<br /><br />Thanx alot!<br /><br />/O.S.
|