SELECT
  TO_CHAR(Message.datetime, 'YYYY-MM-DD HH:MI:SS') AS datetime,
  Message.recipientemail AS recipient_email,
  Message.emailed,
  Message.author,
  Message.authoremail AS author_email,
  Message.hasattachment AS has_attachment,
  Message.htmlmessage AS html_message,
  Message.id,
  Message.internalonly AS internal_only,
  Message.incoming,
  Message.message,
  Message.primaryrecipient AS primary_recipient,
  Message.recipient,
  Message.record,
  Message.recordtype AS record_type,
  Message.subject,
  Message.template,
  <http://Message.to|Message.to>,
  Message.transaction
FROM
  Message
WHERE
  (
    Message.messagedate >= TO_DATE('2022-10-22', 'YYYY-MM-DD')
  )
  AND (
    Message.messagedate <= TO_DATE('2022-10-30', 'YYYY-MM-DD')
  )
ORDER BY
  Message.authoremail,
  message.datetime;