1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75

// Copyright Materialize, Inc. and contributors. All rights reserved.
//
// Use of this software is governed by the Business Source License
// included in the LICENSE file.
//
// As of the Change Date specified in that file, in accordance with
// the Business Source License, use of this software will be governed
// by the Apache License, Version 2.0.

use chrono::{DateTime, NaiveDate, NaiveDateTime, NaiveTime, Utc};

use repr::strconv;

sqlfunc!(
    #[sqlname = "tstostr"]
    #[preserves_uniqueness = true]
    fn cast_timestamp_to_string(a: NaiveDateTime) -> String {
        let mut buf = String::new();
        strconv::format_timestamp(&mut buf, a);
        buf
    }
);

sqlfunc!(
    #[sqlname = "tstztostr"]
    #[preserves_uniqueness = true]
    fn cast_timestamp_tz_to_string(a: DateTime<Utc>) -> String {
        let mut buf = String::new();
        strconv::format_timestamptz(&mut buf, a);
        buf
    }
);

sqlfunc!(
    #[sqlname = "tstodate"]
    fn cast_timestamp_to_date(a: NaiveDateTime) -> NaiveDate {
        a.date()
    }
);

sqlfunc!(
    #[sqlname = "tstztodate"]
    fn cast_timestamp_tz_to_date(a: DateTime<Utc>) -> NaiveDate {
        a.naive_utc().date()
    }
);

sqlfunc!(
    #[sqlname = "tstotstz"]
    #[preserves_uniqueness = true]
    fn cast_timestamp_to_timestamp_tz(a: NaiveDateTime) -> DateTime<Utc> {
        DateTime::<Utc>::from_utc(a, Utc)
    }
);

sqlfunc!(
    #[sqlname = "tstztots"]
    fn cast_timestamp_tz_to_timestamp(a: DateTime<Utc>) -> NaiveDateTime {
        a.naive_utc()
    }
);

sqlfunc!(
    #[sqlname = "tstotime"]
    fn cast_timestamp_to_time(a: NaiveDateTime) -> NaiveTime {
        a.time()
    }
);

sqlfunc!(
    #[sqlname = "tstztotime"]
    fn cast_timestamp_tz_to_time(a: DateTime<Utc>) -> NaiveTime {
        a.naive_utc().time()
    }
);