fix(time): proper database time update

2 files changed, 19 insertions, 2 deletions

diff --git a/src/lib/Database/userBadges.ts b/src/lib/Database/userBadges.ts
index 8816ac40..1f4b5b5b 100644
--- a/src/lib/Database/userBadges.ts
+++ b/src/lib/Database/userBadges.ts
@@ -52,7 +52,8 @@ export const updateUserBadge = async (userId: number, id: number, badge: Badge)
 			post: badge.post,
 			image: badge.image,
 			description: badge.description,
-			category: badge.category
+			category: badge.category,
+			time: badge.time
 		})
 		.eq('id', id)
 		.eq('user_id', userId);
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);
+};