[yunqa.de] Re: License and work

  • From: "Joan Dorrepaal" <joan.dorrepaal@xxxxxxxxx>
  • To: yunqa@xxxxxxxxxxxxx
  • Date: Mon, 8 Sep 2008 16:48:58 +0200

Hi Ralph,

http://www.sqlite.org/cvstrac/wiki?p=UnsupportedSqlAnalyticalFunctions

I run the following code in SQLiteSpy:

create table sum_example (
                                 dt date,
                                 xy number
                                );

        insert into sum_example values (to_date('27.08.1970','DD.MM.YYYY'),4);
        insert into sum_example values (to_date('02.09.1970','DD.MM.YYYY'),1);
        insert into sum_example values (to_date('09.09.1970','DD.MM.YYYY'),5);

It gives me an error: SQLite Error 1 - is no such function: to_date

How can I get this to work?
_______________________________________________
Delphi Inspiration mailing list
yunqa@xxxxxxxxxxxxx
//www.freelists.org/list/yunqa



Other related posts: