blob: 9a8c08a8db197894fc701afc749cff097b3ba087 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
/* syntax version 1 */
select
DateTime::MakeDate(DateTime::Split(`date`)) as rdate,
DateTime::MakeDatetime(DateTime::Split(`datetime`)) as rdatetime,
DateTime::MakeTimestamp(DateTime::Split(`timestamp`)) as rtimestamp,
DateTime::MakeTzDate(DateTime::Split(`tzdate`)) as rtzdate,
DateTime::MakeTzDatetime(DateTime::Split(`tzdatetime`)) as rtzdatetime,
DateTime::MakeTzTimestamp(DateTime::Split(`tztimestamp`)) as rtztimestamp
from (
select
cast(fdate as Date) as `date`,
cast(fdatetime as Datetime) as `datetime`,
cast(ftimestamp as Timestamp) as `timestamp`,
cast(ftzdate as TzDate) as `tzdate`,
cast(ftzdatetime as TzDatetime) as `tzdatetime`,
cast(ftztimestamp as TzTimestamp) as `tztimestamp`
from Input
);
|
