sqlite - SELECT and ADD fields in SQL table -


i have db table created follows :

create table mktdb( mktid number(19) not null, featureid number(20) not null, val varchar(100) not null, primary key (id) ); 

i want view records along additional field having current date each row in db.

i tried following sqlite query erroneous :

select *, current_date mktdb,date; 

don't know sqlite after typing "current date sqllite" in google shows me way https://www.sqlite.org/lang_datefunc.html

and problem:

 select *, date('now') mktdb; 

p.s: wanted try sql fiddle. here is:

http://sqlfiddle.com/#!7/92fd6/3


Comments

Popular posts from this blog

Android : Making Listview full screen -

javascript - Parse JSON from the body of the POST -

javascript - Chrome Extension: Interacting with iframe embedded within popup -