From ac09ee58868131fdef31ca5c49b9394c7521e004 Mon Sep 17 00:00:00 2001 From: Emmi Takkinen Date: Mon, 3 May 2021 10:37:02 +0300 Subject: [PATCH] Bug 14723: Use DATETIME instead DATE Letters.t tests failed since time_queued didn't include timecode. Use DATETIME when inserting into message_queue. To test prove t/db_dependent/Letters.t --- C4/Letters.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Letters.pm b/C4/Letters.pm index c80b328f1d..d0e50982b6 100644 --- a/C4/Letters.pm +++ b/C4/Letters.pm @@ -965,7 +965,7 @@ sub EnqueueLetter { INSERT INTO message_queue ( borrowernumber, subject, content, metadata, letter_code, message_transport_type, status, time_queued, to_address, from_address, reply_address, content_type, delivery_note ) VALUES -( ?, ?, ?, ?, ?, ?, ?, CAST(NOW() AS DATE), ?, ?, ?, ?, ? ) +( ?, ?, ?, ?, ?, ?, ?, CAST(NOW() AS DATETIME), ?, ?, ?, ?, ? ) ENDSQL my $sth = $dbh->prepare($statement); -- 2.25.1