Re: [sqlite] FW: Why aren't there date/time parsing built-in functions in SQLite

t;-Original Message- >From: sqlite-users On Behalf >Of Dominique Devienne >Sent: Tuesday, 10 September, 2019 05:54 >To: SQLite mailing list >Subject: Re: [sqlite] FW: Why aren't there date/time parsing built-in >functions in SQLite > >On Tue, Sep 10, 2019 at 1:

Re: [sqlite] FW: Why aren't there date/time parsing built-in functions in SQLite

Dominique Devienne, on Tuesday, September 10, 2019 07:53 AM, wrote... > > As DRH mentioned recently about a different piece of doc, I suspect that > doc hasn't been updated in years, Is that a hint? :-) josé ___ sqlite-users mailing list sqlite-users@m

Re: [sqlite] FW: Why aren't there date/time parsing built-in functions in SQLite

On Tue, Sep 10, 2019 at 1:27 PM Keith Medcalf wrote: > Also, note that you have to use the 'unixepoch' modifier with the time > function so that it knows the value is seconds, not days, since floats are by default days and integers are by default > seconds. [...] In my quick reading of the doc

[sqlite] FW: Why aren't there date/time parsing built-in functions in SQLite

Also, note that you have to use the 'unixepoch' modifier with the time function so that it knows the value is seconds, not days, since floats are by default days and integers are by default seconds. The 'unixepoch' modifier tells the internal datetime functions that the provided value is relat