SELECT * FROM Plotting_data1 where Time>= '17:30:35' and Time<='17:35:55
SELECT * FROM Plotting_data1 where Time>= '17:30:35' and Time<='17:35:55
To copy to clipboard, switch view to plain text mode
and order by Time???
I think only oracle cam make this.....
Use the UnixTime is more efficient!
all os can handle ....
on mysql
select a,FROM_UNIXTIME(timebounce,'%d.%c.%Y'),....
http://dev.mysql.com/doc/refman/5.0/...functions.html
or
times.setTime_t(resultunixtime);
QDateTime times;
times.setTime_t(resultunixtime);
To copy to clipboard, switch view to plain text mode
const uint now = timer1.toTime_t();
QDateTime timer1( QDateTime::currentDateTime() );
const uint now = timer1.toTime_t();
To copy to clipboard, switch view to plain text mode
1213268102 = Date: Thu, 12 Jun 2008 12:55:02
1213268103 = Date: Thu, 12 Jun 2008 12:55:03
0 = 1.1.1970
on sql order by time desc the new come first && old last...
Bookmarks