diff --git a/erpnext/patches.txt b/erpnext/patches.txt
index 1b0699c..5dab93b 100644
--- a/erpnext/patches.txt
+++ b/erpnext/patches.txt
@@ -263,7 +263,7 @@
 
 [post_model_sync]
 execute:frappe.delete_doc_if_exists('Workspace', 'ERPNext Integrations Settings')
-erpnext.patches.v14_0.update_posting_datetime_and_dropped_indexes
+erpnext.patches.v14_0.update_posting_datetime_and_dropped_indexes #22-02-2024
 erpnext.patches.v14_0.rename_ongoing_status_in_sla_documents
 erpnext.patches.v14_0.delete_shopify_doctypes
 erpnext.patches.v14_0.delete_healthcare_doctypes
diff --git a/erpnext/patches/v14_0/update_posting_datetime_and_dropped_indexes.py b/erpnext/patches/v14_0/update_posting_datetime_and_dropped_indexes.py
index 6ec3f84..ca126a4 100644
--- a/erpnext/patches/v14_0/update_posting_datetime_and_dropped_indexes.py
+++ b/erpnext/patches/v14_0/update_posting_datetime_and_dropped_indexes.py
@@ -5,7 +5,7 @@
 	frappe.db.sql(
 		"""
 		UPDATE `tabStock Ledger Entry`
-			SET posting_datetime = timestamp(posting_date, posting_time)
+			SET posting_datetime = DATE_FORMAT(timestamp(posting_date, posting_time), '%Y-%m-%d %H:%i:%s')
 	"""
 	)