fix: remove microsecond from posting datetime (#40017)
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')
"""
)