PostgreSQL - dates

• PostgreSQL - Find rows created within the last hour / hours
• PostgreSQL - Find rows created within the last month / months
• PostgreSQL - Find rows created within the last week / weeks
• PostgreSQL - Group rows by days
• PostgreSQL - Group rows by months
• PostgreSQL - Group rows by weeks
• PostgreSQL - compare date values
• PostgreSQL - count rows per day
• PostgreSQL - extract century from date/time value
• PostgreSQL - extract day from date/time value
• PostgreSQL - extract day of week from date/time value
• PostgreSQL - extract day of year from date/time value
• PostgreSQL - extract decade from date/time value
• PostgreSQL - extract hour from date/time value
• PostgreSQL - extract seconds from date/time value
• PostgreSQL - extract year from date/time value