((po.date_order AT TIME ZONE 'UTC' AT TIME ZONE 'BOT')::date) as date

,((po.create_date AT TIME ZONE 'UTC' AT TIME ZONE 'BOT')::timestamp) as datetime

,to_char(((po.date_order AT TIME ZONE 'UTC' AT TIME ZONE 'BOT')::date), 'DD/MM/YYYY') as date_format

,to_char(((po.create_date AT TIME ZONE 'UTC' AT TIME ZONE 'BOT')::timestamp), 'DD/MM/YYYY HH:MM:SS') as datetime_format

FROM purchase_order AS po

WHERE ((po.date_order AT TIME ZONE 'UTC' AT TIME ZONE 'BOT')::date) BETWEEN '2015-01-01' AND '2016-05-31';