On 15 Jul 2015, at 1:53pm, Rick <noktar at hotmail.com> wrote:
> 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
Do you have to use regexp ? The following works:
sqlite> SELECT replace('The time is %s.', '%s', strftime('%s','now'));
The time is 1437054006.
Simon.
