time series data and NumPy

Bob Greschke bob at passcal.nmt.edu
Fri Jan 26 13:18:42 EST 2007


On 2007-01-26 10:54:02 -0700, "BBands" <bbands at gmail.com> said:

> On Jan 26, 9:29 am, "Diez B. Roggisch" <d... at nospam.web.de> wrote:
> 
>> What you could do would be to convert the date-column into a timestamp,
>> which is a int/long, and use that. Would that help?
> 
> Actually that might help, as all I need the date for is to index
> values.
> 
> Thanks, I'll give it a spin.
> 
>      jab

You're using the Python-MySQL module mysqldb, right?  You can select 
the data from the database and have MySQL do the conversion with an SQL 
command.

select to_days(<your date column name here>), <your close column> from 
<your table>;

Bob





More information about the Python-list mailing list