1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
/* syntax version 1 */
$format = DateTime::Format("%Y-%m-%d %H:%M:%S %Z");
select
$format(DateTime::StartOfYear(`tztimestamp`)),
$format(DateTime::StartOfQuarter(`tztimestamp`)),
$format(DateTime::StartOfMonth(`tztimestamp`)),
$format(DateTime::StartOfWeek(`tztimestamp`)),
$format(DateTime::StartOfDay(`tztimestamp`)),
$format(DateTime::StartOf(`tztimestamp`, Interval("PT13H"))),
$format(DateTime::StartOf(`tztimestamp`, Interval("PT4H"))),
$format(DateTime::StartOf(`tztimestamp`, Interval("PT15M"))),
$format(DateTime::StartOf(`tztimestamp`, Interval("PT20S"))),
$format(DateTime::StartOf(`tztimestamp`, Interval("PT7S"))),
DateTime::TimeOfDay(`tztimestamp`)
from (
select
cast(ftztimestamp as TzTimestamp) as `tztimestamp`
from Input
);
|
