The datetime tag has no wiki summary.
0
votes
2answers
24 views
A query for a latest version of data
MySQL.
Let there is a table with fields startdate and kind.
Actually in the real problem column named here startdate and kind are in a UNIQUE index, but the case if only startdate (not kind) is ...
0
votes
1answer
25 views
look for missing datetime records in database
I have a python script that scrapes a webpage every minute of every day and saves the results in a postgres database.
As I browse through the database, I've noticed there are minutes here and there ...
0
votes
2answers
120 views
Get most recent 100 records from the database
I am using SQL Server 2008, we have one database which contains 150 tables. We have introduced systimestamp DATETIME column in every tables. We do update this column with current timestamp whenever ...
0
votes
0answers
62 views
Unable to fetch recently inserted entries via Astyanax in cassandra
I'm using Cassandra server with random partitioner. Table(Column family) has a col1 and timestamp column as one of the secondary indexes. Column family has 400000 rows aprox.
Number of rows returned ...
0
votes
1answer
132 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 ...
2
votes
1answer
184 views
How can I calculate time spent at work in a single column?
I would like to calculate the amount of time spent working from rows of data that contain a single date/time field.
The first occurrence on a given day can be considered the start time, with the ...
1
vote
1answer
185 views
TSQL DateTime DataType - fractional seconds vs milliseconds
Wanting to get all records from a single day. So everything between 2013-03-05 00:00:00.000 and 2013-03-05 23:59:59.999. We're getting overlap at the backend with things that happened at 2013-03-06 ...
2
votes
1answer
135 views
What happens when changing column type DATETIME to TIMESTAMP in MySQL?
I want to convert a column data type from DATETIME to TIMESTAMP in a table with more than one million of lines.
Is it possible? Is it slow? Will I loose the old information or MySQL can convert this ...
