fix(time): proper database time update

1 files changed, 17 insertions, 1 deletions

diff --git a/src/lib/Utility/time.ts b/src/lib/Utility/time.ts
index 26fdc0ee..4ab72212 100644
--- a/src/lib/Utility/time.ts
+++ b/src/lib/Utility/time.ts
@@ -1,4 +1,20 @@
 export const databaseTimeToDate = (time: string) => new Date(time + 'Z');
 
 export const dateToDatabaseTime = (date: Date) =>
-	date.toISOString().replace(' ', 'T').replace(' ', 'Z');
+	date.toISOString().replace('T', ' ').replace(/\..+/, '');
+
+export const dateToInputTime = (date: Date) => {
+	const offset = date.getTimezoneOffset();
+
+	date.setMinutes(date.getMinutes() - offset);
+
+	return date.toISOString().slice(0, 16);
+};
+
+export const inputTimeToDatabaseTime = (date: Date) => {
+	const offset = date.getTimezoneOffset();
+
+	date.setMinutes(date.getMinutes() + offset);
+
+	return dateToDatabaseTime(date);
+};