On 6/8/20 3:10 PM, David G. Johnston wrote:
On Mon, Jun 8, 2020 at 2:57 PM Alistair Johnson <aewj@xxxxxxx
<mailto:aewj@xxxxxxx>> wrote:
RETURN EXTRACT(datepart FROM end - start);
Any ideas? Is this even possible?
Use the "date_part" function.
That would work on the Postgres side, but the OP also wants this to run on BigQuery and unfortunately it won't work there.
David J.
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx
