|
In sybase is there any built in functions to convert a seconds value into hours, minutes, and seconds?
Started by bobwah on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Can use this:
datepart(hour, dateadd(second, value, '1900-01-01')) datepart(minute, dateadd(second, value, '1900-01-01')) datepart(second, dateadd(second, value, '1900-01-01'))
A common 'seconds do something like
select....
|
|
Whats an easy way to convert 00:20:40.28 to seconds with a bash script? (Split seconds can be cut out, it’s not essential.)
Started by Mint on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Mytime=’00:20:40.28′ part1=${mytime%%:*}; rest=${mytime#*:} part2=${rest%%:*}; rest=${rest#*:} part3=${rest....
Followed by multiplying by the appropriate amounts for hours and minutes .
I haven't tested this but, I think this is how you'd split the string .
|
|
I am having a terrible time trying to do something that should be easy. I have a NSNumber value of 32025.89 seconds. I need to represent that in Hours, Minutes, Seconds. Is there a method that spits that out? I can't seem to find a proper formatter.
Started by SonnyBurnette on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Note: It doesn't account for sub-second precision(@"%d hours, %d minutes, %d seconds", [result hour], [result minute], [result second]);
Have you tried.
It may be close enough for your purposes.
Try this.
|
Ask your Facebook Friends
|
Exactly every 600 seconds (10 minutes) my 2wire 2701HG-B has latency go from around 15ms to between 400ms and 800ms. This lasts for between 108 seconds and 113 seconds averaging 110 seconds.
This is true for both wired and wireless. I've tried it on multiple...
Started by Paul Tarjan on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
The upload time was....
I had a machine that was plugged into the network, that every 10 minutes would attempt to send a huge email .
Have you tried applying the latest firmware updates?
Well, I feel very embarrassed posting this, but it might help others .
|
|
Suppose I have 90 seconds. If I want to display the result in terms of minutes and second, I do it by using
select Time= '0' + CAST( 90/60 as varchar(2)) + ':' + CAST( 90%60 as varchar(2))
The output is
Time 01:30
I have appended 0(zero) because if you...
Started by priyanka.bangalore on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
With hours:
SELECT CONVERT(CHAR(8),DATEADD(second,90,0),108) 00:01:30
Ignoring hours:
SELECT RIGHT(CONVERT(CHAR(8),DATEADD(second,90,0),108),5) 01:30
One of the first things I do on a fresh SQL database is add a Timespan function similar to this one ... .
|
|
Hi,
I have a need to run a piece of code every 120 seconds. I am looking for an easy way to do this in VBA. I know that it would be possible to get the timer value from the Auto_Open event to prevent having to use a magic number, but I can't quite get...
Started by FinancialRadDeveloper on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Sub Form_Load() Me.TimerInterval = 1000 '1000 = 1 second End Sub Sub Form_Timer() 'Do Stuff.
Action.
|
|
I have two programs written in C++ that use Winsock. They both accept TCP connections and one sends data the other receives data. They are compiled in Visual Studio 2008. I also have a program written in C# that connects to both C++ programs and forwards...
Started by Logikal on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You should profile your application on the good, 2 second case, and the 15 second lab case and see.
|
|
I want to write some functions for that, but before I do: Are there any to convert between time units?
Started by Thanks on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Ex:
DateTime....
This difference then can be presented as seconds, minutes or hours or days...
TimeSpan holds the differnce between 2 datetime objects.
Use the object called TimeSpan.
If you are using .Net platform then you have a solution straight .
|
|
Started by thejokermask on
, 16 posts
by 3 people.
Answer Snippets (Read the full thread at reddit):
That he doesn't care about being labeled "second." He's saying he's used to it by now.
|
|
I bought a new monitor (Acer X203H) and wanted to plug it into my graphics card but on my graphics card one plug says CRT which is already filled with the first monitor and the second says DVI , which I don't have a cable for on my second monitor.
So ...
Started by Edward Tanguay on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at superuser):
The second option would be a DVI-VGA connector, but first verify.
Solution would be a DVI-DVI cable.
|
