Re: analyzing time

2013-07-05 Thread Gary Herron
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

Re: analyzing time

2013-07-05 Thread Terry Reedy
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

Re: analyzing time

2013-07-05 Thread Skip Montanaro
> 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

Re: analyzing time

2013-07-05 Thread Neil Cerutti
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

analyzing time

2013-07-05 Thread noydb
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