Thanks Sarah, i will give that a try. Looks more professional than my workaround i used to go further on:
set the itemdelimtiter to ":" convert tTimestamp from seconds to the short system time add -1 to item 1 of tTimestamp set the itemdelimiter to TAB @BNig Thanks, thought about this already, but the program has to be run on a client computer, where we cannot adjust region settings due to missing permissions. Regards, Matthias -------- Original Message -------- Subject: Re: Re-2: some trouble with convert (01-Sep-2008 23:25) From: Sarah Reichelt <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] > > I get a timestamp in seoncds from a database e.g 1220298324 which is equal > > to 21:45:24. I then take the actual time (also in seconds) and want to > > compare the actual time with this timestamp to find out the difference.I > > just substract the timestamp from the actual time in seconds to get the > > difference. Lets say the difference is 1754 seconds (29minutes 14seconds). > > Now i convert the seconds into the short system time and get 01:29:14 and > > not 0:29:14. The result shows 1 hour more than it should do. > > > > To avoid posting my original code (i am using german expressions in my code) > > i created the example, which shows the same behaviour. > > > > > > put 1754 into tTimestamp > > convert tTimestamp to short system time -- converts from seconds to short > > system time > > put tTimestamp -- shows 01:29:14 in messagebox, > > but should be 0:29:14 > > > > How can i solve this? Any ideas are welcome. > > The "convert" command allows for time zones so the same value in > seconds will give different times & dates depending on the time zone > of the converting computer. > In this case, where you are trying to get the difference between 2 > times, I think the best option is to convert the difference in seconds > into hours & minutes manually. > > Try this function: > > function secondsToTime pSecs > put pSecs div 3600 into tHours > put pSecs mod 3600 into tMinsSecs > > put tMinsSecs div 60 into tMins > put tMinsSecs mod 60 into tSecs > > if tMins < 10 then put "0" before tMins > if tSecs < 10 then put "0" before tSecs > > return tHours & ":" & tMins & ":" & tSecs > end secondsToTime > > Cheers, > Sarah > _______________________________________________ > use-revolution mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > > > > > To: [email protected] _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
