note 53019 deleted from function.sqlite-create-function by cmb
| From: | cmb@php.net | Date: | Mon, 02 Nov 2020 14:58:33 +0000 |
| Subject: | note 53019 deleted from function.sqlite-create-function by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-215724@lists.php.net to get a copy of this message | ||
Note Submitter: Brett
----
In my previous comment, there was an error in the code which was causing the issue.
Removing the surrounding quotes from from_unixtime()'s return value solved the issue, and so
UDFs _do work_ from within DELETEs and INSERTs! Yay!
<?php
// SQLite UDF
// Mimic MySQL FROM_UNIXTIME
function from_unixtime($unixtime)
{
return date('Y-m-d H:i:s', $unixtime); // no surrouding quotes
}
?>