Hi,

I am looking for monerdb to replace mysql. I tried some queries with my test data and all were much more faster than mysql.

But our actual table contains a column which stores date in unix time format and we do generate reports based on week, day, quarter, month and year. For that we are using a lot mysql date related functions.

I too tried the following approach for one of my requirements.

cast(timestamp '1970-01-01 00:00:00' + cast(created_date/1000 as interval second) as date)

but it takes longer time.

1) Is there any other way to make this query faster ?

2) what are all the options are available in monetdb to deal these (week,quarter,hour,day and year wise reporting) kind of queries.

Any help will be appreciated.

Thanks and Regards Ram