Have you looked at https://www.sqlite.org/src/artifact/af92cdaa5058fcec ?
Simon wrote:
|
| Do you have to use regexp ? The following works:
|
| sqlite> SELECT replace('The time is %s.', '%s', strftime('%s','now'));
| The time is 1437054006.
|
|
| On 15 Jul 2015, Rick asked:
| >
| > Is there a simple way to replace portions of a string using the regex
| > function of sqlite without actually accessing any specific DB entres.
| >
| > Similar to
| >
| > SELECT strftime('%s','now') as unixtimestamp
| >
|
