Questions tagged [seconds]
333 questions
2
votes
1 answer
How to convert time from hh:mm:ss.mmm to seconds and milliseconds mysql
I would like to convert all values in a column from "hh:mm:ss.mmm" to "ss.mmm".
I have tried TIME_FORMAT(Duration, 's%.f%) but this shows the seconds and milliseconds and doesn't keep calculate the correct seconds when values are over 1…
Isabel
- 37
- 6
2
votes
1 answer
How to make C++ program doing 2 things simultaneously?
Can someone tell me what do I need to do (not to write me code, just tell me) to make C++ doing 2 things simultaneously?
Let's say that I have some timer and some text.
That text moves every 0.5 seconds to the right and times updates every 1…
SomeName
- 909
- 2
- 8
- 15
2
votes
1 answer
UIDatePicker as Countdown timer with seconds (Swift)
So, apple updated the timer app in IOS 11, and one of the most useful things they've done is add a seconds column in the countdown timer, like this:
countdown timer
I am building an app for personal use and need to use the timer, but for intervals…
Gustavo Furtado
- 21
- 1
- 5
2
votes
1 answer
Convert seconds to '00:00:00' format - SQL Server
I have a report in which i have to calculate overall worked hours by any employee in a week. The report reflects hours more than 24 hours(or 86400 seconds). I want to convert all the seconds into "00:00:00" format keeping the format of the columns…
ankur jain
- 67
- 1
- 10
2
votes
1 answer
SQL Difference between two times in seconds
SELECT Warehouses.Name,
RIGHT(CONVERT(VARCHAR,AirwayBillTrucks.CheckOutTime,100),7) AS CheckOutTime,
RIGHT(CONVERT(VARCHAR,AirwayBillTrucks.ReturnTime,100),7) AS ReturnTime
That is my piece of code, CHECKOUTTIME and RETURNTIME…
Sabi Tech
- 81
- 1
- 12
2
votes
2 answers
PHP - get milliSecond from Timestamp
I want to get current Timestamp with millisecond. but date() returns Timestamp just with seconds.
Majid Sadr
- 911
- 7
- 18
2
votes
3 answers
C/C++ time_t in microseconds
This program returns the time in seconds. I need to return it in microseconds.
time_t timeStart = time(0);
usleep(2.5e6);
time_t timeEnd = time(0);
float R = (timeEnd - timeStart);
std::cout << R << std::endl;
Strife
- 39
- 1
- 1
- 3
2
votes
0 answers
difference between 2 dates in seconds with timezone using standard modules python?
How to find the difference between 2 dates in seconds with timezone only using the python standard modules such as datetime, time etc.. not with dateutil, pytz etc... This is not a duplicate question.
from datetime import datetime
t2 =…
cracker
- 445
- 1
- 5
- 10
2
votes
4 answers
Java currentTimeMillis() conversion to seconds not working?
Im trying to convert milliseconds to seconds with System.currentTimeMillis();
System.out.println((int) System.currentTimeMillis() / 1000);
The output is 730750 and increasing by 1. How can i get seconds starting from 0?
**UPDATE: Now i understand…
Mert Karakas
- 178
- 1
- 4
- 22
2
votes
1 answer
R adding to a difftime vector forgets about the units
When I extend a vector of difftimes by another difftime object, then it seems that the unit of the added item is ignored and overridden without conversion:
> t = Sys.time()
> d = difftime(c((t+1), (t+61)), t)
> d
Time differences in secs
[1] 1…
laubbas
- 186
- 1
- 5
2
votes
1 answer
Find files created over a certain number of seconds ago then copy it
So I'm trying to make a script that watches for files that haven't been modified for at least 10 seconds then to execute an rsync on the file. My original line was this:
find "/Volumes/Media/" -type f -size +2G -cmin +1 -cmin -60 -exec rsync -aq…
NOTaMango
- 73
- 5
2
votes
0 answers
Oracle Timestamp before 1970 - seconds value incorrect
The following SQL run on Oracle 11g returns an incorrect 'seconds' value for dates before 1970-01-01 when fractional seconds are present.
Is there something wrong with the SQL?
alter session set nls_timestamp_format='SS';
select
…
cp2014
- 21
- 2
2
votes
1 answer
Linux task schedule to Hour, minute, second
I'm trying to run a shell script at a specific time up to it's seconds (H:M:S) , but so far all programs such as at only go up to a specific minute (not second).
I don't want to use sleep since it's not accurate. For some reason it ended couple of…
user3334860
- 53
- 2
- 6
2
votes
2 answers
Convert QDate to seconds
I take date from QDateTimeEdit and convert it to seconds like this:
import time
from datetime import datetime
date = self.__ui.dateTimeEdit.date().toString("dd/MM/yy")
dateString = str(date)
seconds = time.mktime(datetime.strptime(dateString,…
Aleksandar
- 3,541
- 4
- 34
- 57
2
votes
1 answer
oracle date to string
I have this problem: I want to convert the sysdate to string, using fillmode on month, day and hour only. However,
select to_char(sysdate, 'fmmm/fmdd/yyyy fmhh12:mi:ss am') from dual
gives me results like
11/13/2013 9:45:**0** am
although it…
Willi Fischer
- 455
- 6
- 21