[sqlite] How to perform regex on string

[Simon Slavin]

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.