reifydb_function/datetime/
age.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, date::Date, duration::Duration, r#type::Type};
6
7use crate::{
8	ScalarFunction, ScalarFunctionContext,
9	error::{ScalarFunctionError, ScalarFunctionResult},
10	propagate_options,
11};
12
13pub struct DateTimeAge;
14
15impl DateTimeAge {
16	pub fn new() -> Self {
17		Self
18	}
19}
20
21impl ScalarFunction for DateTimeAge {
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							// Extract time nanos since midnight
48							let nanos1 = dt1.time().to_nanos_since_midnight() as i64;
49							let nanos2 = dt2.time().to_nanos_since_midnight() as i64;
50							let mut nanos_diff = nanos1 - nanos2;
51							let mut days_borrow: i32 = 0;
52
53							if nanos_diff < 0 {
54								days_borrow = 1;
55								nanos_diff += 86_400_000_000_000;
56							}
57
58							// Extract date parts
59							let date1 = dt1.date();
60							let date2 = dt2.date();
61
62							let y1 = date1.year();
63							let m1 = date1.month() as i32;
64							let day1 = date1.day() as i32;
65
66							let y2 = date2.year();
67							let m2 = date2.month() as i32;
68							let day2 = date2.day() as i32;
69
70							let mut years = y1 - y2;
71							let mut months = m1 - m2;
72							let mut days = day1 - day2 - days_borrow;
73
74							if days < 0 {
75								months -= 1;
76								let borrow_month = if m1 - 1 < 1 {
77									12
78								} else {
79									m1 - 1
80								};
81								let borrow_year = if m1 - 1 < 1 {
82									y1 - 1
83								} else {
84									y1
85								};
86								days += Date::days_in_month(
87									borrow_year,
88									borrow_month as u32,
89								) as i32;
90							}
91
92							if months < 0 {
93								years -= 1;
94								months += 12;
95							}
96
97							let total_months = years * 12 + months;
98							container.push(Duration::new(total_months, days, nanos_diff));
99						}
100						_ => container.push_default(),
101					}
102				}
103
104				Ok(ColumnData::Duration(container))
105			}
106			(ColumnData::DateTime(_), other) => Err(ScalarFunctionError::InvalidArgumentType {
107				function: ctx.fragment.clone(),
108				argument_index: 1,
109				expected: vec![Type::DateTime],
110				actual: other.get_type(),
111			}),
112			(other, _) => Err(ScalarFunctionError::InvalidArgumentType {
113				function: ctx.fragment.clone(),
114				argument_index: 0,
115				expected: vec![Type::DateTime],
116				actual: other.get_type(),
117			}),
118		}
119	}
120
121	fn return_type(&self, _input_types: &[Type]) -> Type {
122		Type::Duration
123	}
124}
reifydb_function/datetime/age.rs

reifydb_function/datetime/
age.rs
