Hello
I'm wandering if CAST is supposed to work?
Documentation says that it "changes the datatype of the into the type specified
by <type>".
However I don't observer any change. It even alters data in not obvious way:
SQLite version 3.3.17
Enter ".help" for instructions
sqlite> create table tab(col date);
sqlite> insert into tab values('1994-11-11');
sqlite> create table tab2 as select cast(col as DATE) from tab;
sqlite> .schema tab2
CREATE TABLE tab2("cast(col as DATE)");
sqlite> select * from tab2;
1994
sqlite> create table tab3 as select cast(col as DATE) as col from tab;
sqlite> .schema tab3
CREATE TABLE tab3(col);
sqlite> select * from tab3;
1994
----------------------------------------------------------------------
Po meczu.....kurde...:)
>>> http://link.interia.pl/f1a72
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
