python - Change index to date/time type in pandas? -

i made dataframe sqlite3 database with

df = sql.read_frame("select * hzmo_report;", cnx, index_col='datum') 

print df.dtypes -> givers me:

id                   int64 osiguranika          int64 korisnika            int64 omjer              float64 mirovina           float64 udio               float64 neto_placa           int64 neto_datum          object sredstva             int64 dzd_korisnika        int64 dzd_djece            int64 dzd_sredstva_sr    float64 dzd_sredstva_bz    float64 dzd_isplata          int64 url                 object 

value of id, named 'datum' in data base is:

print df.index index([2012-12-01, 2013-01-01, 2012-11-01, 2013-02-01, 2012-09-01, 2012-10-01, 2012-08-01, 2012-07-01, 2012-06-01, 2012-05-01, 2012-04-01, 2012-03-01, 2012-02-01, 2011-12-01, 2011-11-01, 2011-10-01, 2011-09-01, 2011-08-01, 2011-07-01, 2011-06-01, 2011-05-01, 2011-04-01, 2011-03-01, 2012-01-01, 2011-02-01, 2011-01-01, 2010-12-01, 2010-11-01, 2010-10-01, 2010-09-01, 2010-08-01, 2010-07-01, 2010-06-01, 2010-05-01, 2010-04-01, 2010-03-01, 2010-02-01, 2010-01-01, 2009-12-01, 2009-10-01, 2009-11-01, 2013-03-01], dtype=object) 

so how change id(index) int64 type date/time type ?

i wont id sorted.

also how remove date index, because have 1 entry per mouth frequency should monthly. eg. 2012-12-01 2012-12 , on.

update:

when constructing dataframe sql database never use sql query without order "your date column"

this important, because otherwise, dataframe not ordered date column.

so sql

 df = sql.read_frame("select * hzmo_report;", cnx, index_col='datum') 

should be:

df = sql.read_frame("select * hzmo_report order datum;", cnx, index_col='datum') 

try using pandas.periodindex(df.index, freq='m')