reifydb_function/datetime/
diff.rs

1// SPDX-License-Identifier: AGPL-3.0-or-later
2// Copyright (c) 2025 ReifyDB
3
4use reifydb_core::value::column::data::ColumnData;
5use reifydb_type::value::{container::temporal::TemporalContainer, duration::Duration, r#type::Type};
6
7use crate::{
8	ScalarFunction, ScalarFunctionContext,
9	error::{ScalarFunctionError, ScalarFunctionResult},
10	propagate_options,
11};
12
13pub struct DateTimeDiff;
14
15impl DateTimeDiff {
16	pub fn new() -> Self {
17		Self
18	}
19}
20
21impl ScalarFunction for DateTimeDiff {
22	fn scalar(&self, ctx: ScalarFunctionContext) -> ScalarFunctionResult<ColumnData> {
23		if let Some(result) = propagate_options(self, &ctx) {
24			return result;
25		}
26		let columns = ctx.columns;
27		let row_count = ctx.row_count;
28
29		if columns.len() != 2 {
30			return Err(ScalarFunctionError::ArityMismatch {
31				function: ctx.fragment.clone(),
32				expected: 2,
33				actual: columns.len(),
34			});
35		}
36
37		let col1 = columns.get(0).unwrap();
38		let col2 = columns.get(1).unwrap();
39
40		match (col1.data(), col2.data()) {
41			(ColumnData::DateTime(container1), ColumnData::DateTime(container2)) => {
42				let mut container = TemporalContainer::with_capacity(row_count);
43
44				for i in 0..row_count {
45					match (container1.get(i), container2.get(i)) {
46						(Some(dt1), Some(dt2)) => {
47							let diff_nanos =
48								dt1.to_nanos_since_epoch() - dt2.to_nanos_since_epoch();
49							container.push(Duration::from_nanoseconds(diff_nanos));
50						}
51						_ => container.push_default(),
52					}
53				}
54
55				Ok(ColumnData::Duration(container))
56			}
57			(ColumnData::DateTime(_), other) => Err(ScalarFunctionError::InvalidArgumentType {
58				function: ctx.fragment.clone(),
59				argument_index: 1,
60				expected: vec![Type::DateTime],
61				actual: other.get_type(),
62			}),
63			(other, _) => Err(ScalarFunctionError::InvalidArgumentType {
64				function: ctx.fragment.clone(),
65				argument_index: 0,
66				expected: vec![Type::DateTime],
67				actual: other.get_type(),
68			}),
69		}
70	}
71
72	fn return_type(&self, _input_types: &[Type]) -> Type {
73		Type::Duration
74	}
75}
reifydb_function/datetime/diff.rs

reifydb_function/datetime/
diff.rs
