yql/essentials/udfs/common/datetime2/test_bigdates/cases/Parse64TzOffset.sql


1
2
3
4
5
6
7
8
9

$parseNginx = DateTime::Parse64("%d/%b/%Y:%H:%M:%S %z");
$parseTzOffset = DateTime::Parse64("%Y-%m-%dT%H:%M:%S with %z offset");

$format = DateTime::Format("%Y-%m-%dT%H:%M:%S%z(%Z)");

select
    $format($parseNginx(fnginx)) as onginx,
    $format($parseTzOffset(fdatetime)) as odatetime,
from Input;