Note https://www.sqlite.org/datatype3.html says:
"Applications can chose to store dates and times in any of these
formats and freely convert between formats using the built-in date and
time functions."
This is partially true. The date and time functions will optionally
parse 'a timezone indicator
On Tue Jul 23, 2019 at 04:41:59PM +0200, Andreas Kretzer wrote:
> Am 23.07.2019 um 16:22 schrieb Steve Leonard:
> >
> > 4)I have tried several combinations of creating a new field
> > of type numeric, blob, real, and integer and then tried to update
If you want to work with date *strings* of the
Hi Steve,
beside what I said in my last statement, you should also
have a look at
https://www.sqlite.org/datatype3.html
https://www.sqlite.org/lang_datefunc.html
This may help you to understand, how SQLite handles specific
data types, that might be understood (or at least be handled)
Am 23.07.2019 um 16:22 schrieb Steve Leonard:
>
> 1) I imported a new table using dbbrowser for sqlite from a csv file
> one of the fields is named myfdat and the first record contains
> '12/01/2011'
>
> 2) the import created a table with the field myfdt as type text and
> the value matches the
1) I imported a new table using dbbrowser for sqlite from a csv file
one of the fields is named myfdat and the first record contains '12/01/2011'
2) the import created a table with the field myfdt as type text and the
value matches the csv file
3) I want to select all records where myfdt is
5 matches
Mail list logo