On 07/05/2013 12:18 PM, noydb wrote:
Hello All,
I have a table with a column of type date, with dates and time combined (like
'1/6/2013 3:52:69PM'), that spans many months. How would I pull out records
that are the first and last entries per day?
Also, if I wanted to find time clusters per d
On 7/5/2013 3:18 PM, noydb wrote:
I have a table with a column of type date, with dates and time
This is a datetime in Python parlance.
combined (like '1/6/2013 3:52:69PM'), that spans many months. How
would I pull out records that are the first and last entries per
day?
Sort on that colu
> I have a table with a column of type date, with dates and time combined (like
> '1/6/2013 3:52:69PM'), that spans many months. How would I pull out records
> that are the first and last entries per day?
You mentioned "table" and "column", which leads me to think you are
dealing with data in a
On 2013-07-05, noydb wrote:
> Hello All,
>
> I have a table with a column of type date, with dates and time
> combined (like '1/6/2013 3:52:69PM'), that spans many months.
> How would I pull out records that are the first and last
> entries per day?
>
> Also, if I wanted to find time clusters per
Hello All,
I have a table with a column of type date, with dates and time combined (like
'1/6/2013 3:52:69PM'), that spans many months. How would I pull out records
that are the first and last entries per day?
Also, if I wanted to find time clusters per day (or per week) -- like if an
entry i