All Questions
8 questions
0
votes
1
answer
251
views
Converting MySQL 5.5 datetime binary to MySQL 5.6 (math problem)
I received a database "backup" of binary files (.frm and .ibd) that were copied from a MySQL 5.5 install. Unfortunately, I was unable to get these files to import into a MySQL 5.5 vm that I created. ...
- 5
5
votes
1
answer
37
views
Combine individual sensor values into an overall value with correction factors
For a school project, we are trying to calculate (corrected) Ozone values based on a combination of 5 sensors (3x O3, 1x temp, 1x humidity).
We are using MySQL and PHP for the rest of the project.
...
- 53
0
votes
1
answer
268
views
Why does this SQL work on one version of MySql-Server but not another?
I'm trying to run the following very simple SQL command on two different MySQL databases:
CREATE TABLE mytable (
created DATETIME(6) NOT NULL,
updated DATETIME(6) NOT NULL,
my_id ...
- 103
3
votes
1
answer
21k
views
MySQL - Truncated incorrect datetime value on update statement
I have an application which produces log files. These log files include a Timestamp field in the format 2015-08-25T09:35:01 UTC.
(there will be approximately 60 logs produced at 0.25 GB per day).
I ...
- 2,186
1
vote
2
answers
3k
views
What happens when we take a timediff between timestamp and datetime
Say I have following table in mysql (5.5+):
CREATE TABLE IF NOT EXISTS `test` (
`id` int(11) NOT NULL,
`x_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`y_time`...
- 111
0
votes
1
answer
142
views
How can I efficiently search for all records from a given month, or a given year?
We have a couple queries that involve datetime fields. In particular, we are checking for things like
SELECT field1, field2, ..., field20 FROM table WHERE MONTH(startDate) == 1
SELECT field1, field2, ...
- 359
2
votes
2
answers
119
views
Get rows in a range of time
I have a table with two columns that stores TIME type values. This is the CREATE statement:
CREATE TABLE `sdriving_turno` (
`idturno` bigint(20) NOT NULL AUTO_INCREMENT,
`idempresa` int(10) ...
- 195
7
votes
2
answers
92k
views
How to get only month from MySQL date/time?
In my MySQL server, I have rows that have the date of my created content.
Example: 2013-03-17 02:53:47
For now, I am using:
$date = $fetch[thedaterownamegoeshere];
<?php echo $date; ?>
But ...
- 267