On 25 Aug 2019, at 10:09pm, André Borchert <0xa...@gmail.com> wrote:
> I try to copy one table into a second identical one. Once the second table is
> created I want to move the content over sorted by ASC.
It's worth noting here that the rows of a table do not have any order in SQL.
A table
Which version of SQLite3 are you using? Tip of trunk seems to work correctly
...
SQLite version 3.30.0 2019-08-24 20:18:04
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> create table x(x);
sqlite>
Hello,
I try to copy one table into a second identical one. Once the second table
is created I want to move the content over sorted by ASC.
The issue is that the ORDER BY statement gets ignored during a INSERT INTO:
INSERT INTO CompanyDetails2 SELECT * FROM CompanyDetails WHERE
On Saturday, 24 August, 2019 11:12, Petr Slansky wrote:
>past, I tried to find some old dates and I found a bug in date()
>function for date in range -1000- (1000BC-0BC)
There is no 0 BC. The day immediately before 0001-01-01 AD/CE was 0001-12-31
BC(E), and what you refer to as -1000 is
On August 24, 2019 1:12:21 p.m. EDT, Petr Slansky wrote:
>I discovered julianday() function and because it is linked to the
>distant
>past, I tried to find some old dates and I found a bug in date()
>function for
>date in range -1000- (1000BC-0BC):
>
>sqlite> select date('-1000-01-01'); -- OK
I discovered julianday() function and because it is linked to the distant
past, I tried to find some old dates and I found a bug in date() function for
date in range -1000- (1000BC-0BC):
sqlite> select date('-1000-01-01'); -- OK
-1000-01-01
sqlite> select date('-0999-01-01'); -- BUG, should
6 matches
Mail list logo
