SQLite Forum

Time of
Login
What Warren said... And, the function to change the slashes into dashes is:

```
  replace(OriginalText, StuffToReplace, StuffToReplaceItWith)
```

So that, using Warren's example, it becomes:

```
  SELECT julianday(replace(hours2,'/','-')) - julianday(replace(hours1,'/','-'))
    FROM mytable
   WHERE criterion;

```