var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: how to calculate time part
I HAVE STRING COLUMN SAY "TIME_USED" WITH 'HOURS:MINSECONDS' (eg 153:29:41) FORMAT
I NEED TO CALCULATE IT TYPICALLY AND STORE IT IN SOME OTHER VARIABLE PLEASE CHECK;
--> (MINS.SECONDS)/60 ie (29.41)/60=0.4901
and concatinate this value to HOURS ie 153.4901
how to do this, i cant use like operator and get the data and do in one go for sql, can any one help me out
As ever, this sort of thing would have been much easier if the designer had not tried to be clever and simply had a start date\time and an end date\time column.
Can you see how to get it from this?
the_seconds = PARSENAME(REPLACE('153:29:41', ':', '.'), 1)
, the_minutes = PARSENAME(REPLACE('153:29:41', ':', '.'), 2)
, the_hours = PARSENAME(REPLACE('153:29:41', ':', '.'), 3)
ur codings are working excelent.