Re: [sqlite] how do this stuff in sqlite

anyone can help me? - Original Message From: Igor Tandetnik <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Thursday, November 27, 2008 12:07:31 PM Subject: Re: [sqlite] how do this stuff in sqlite "Rachmat Febfauza" <[EMAIL PROTECTED]> wrote in message

Re: [sqlite] how do this stuff in sqlite

Define "don't work". Do you get an error? What's the error text? i mean it can be run but the result doesn't like mysql do. whats wrong with my query? Begin and End are keywords in SQLite (SQL is case insensitive). If you insist on naming your columns this way, you have to enclose the names in

Re: [sqlite] how do this stuff in sqlite

Rachmat, I also noted that one of your queries includes: time_to_sec(timediff(akhir1.End, awal1.Begin)) I think time conversion routines are part of each database vendor's implementation -- and not part of the sql standard, so you'll need to convert to the time routines provided in sqlite

Re: [sqlite] how do this stuff in sqlite

"Rachmat Febfauza" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > i have query that don't work in sqlite but in mysql work and make > good result. Define "don't work". Do you get an error? What's the error text? > CREATE TABLE hasil1 (Code char(5), Level vachar(8), Category

[sqlite] how do this stuff in sqlite

i have query that don't work in sqlite but in mysql work and make good result. sqlite : table definition CREATE TABLE awal1(Code char(5),Level varchar(8), Category varchar(50), Product varchar(60),  Location varchar(50), "begin" datetime); CREATE TABLE akhir1(Code char(5),Level