Something like 'to_days' in postgresql? Help with a MySQL migration...
От
Alan T. Miller
Тема
Something like 'to_days' in postgresql? Help with a MySQL migration...
Дата
Msg-id
0e9b01c3bfc3$72898950$640a0a0a@webdev
Список
Дерево обсуждения
Something like 'to_days' in postgresql? Help with a MySQL migration... "Alan T. Miller" <amiller@hollywood101.com>
Re: Something like 'to_days' in postgresql? Help with a Oliver Elphick <olly@lfix.co.uk>
Re: Something like 'to_days' in postgresql? Help with a Oliver Elphick <olly@lfix.co.uk>
Re: Something like 'to_days' in postgresql? Help with a MySQL migration... Bruno Wolff III <bruno@wolff.to>
Re: Something like 'to_days' in postgresql? Help with a MySQL Sai Hertz And Control Systems <sank89@sancharnet.in>
I am migrating an application over from mysql to postgresql and am a little confused on how to write the following query in PostgreSQL. The date functions and syntax is a world apart from MySQL and what I am used to. To sum it up, I want to select a count of all records in a table that have been added in the last 90 days. My current table has a field called 'created' which is a timestamp. In MySQL the query goes as follows... SELECT COUNT(*) AS total FROM orders WHERE id = 'id' AND TO_DAYS(NOW()) - TO_DAYS(created) <= 90 If someone thinks this is easy enough, it would be even more helpful if someone could suggest the most efficient was to do the same query but perhaps return the total for the last 7 days, the last 30 days, and the last 90 days in the same query. I know I can run the query three times but I was hoping for a suggestion that might be more efficient. Thanks in advance. Alan
В списке pgsql-novice по дате отправления