Please note: Many dates listed below are to be confirmed.

SELECT ItemID, Event, to_char(StartDate,'yyyy-mm-dd'), to_char(StartDate,'DDth'), to_char(EndDate,'yyyy-mm-dd'), to_char(EndDate,'DDth'), Venue, StartDate <= EndDate FROM Calendar WHERE EndDate >= datetime(to_char('now'::datetime,'DD Mon YYYY')) ORDER BY StartDate, EndDate
ERROR: type "datetime" does not exist There are no upcoming events to display