[sqlite] Date/Time as Default Value

[Frank Fabbrocino]

I would like to have a default value for a column be the current time. This is 
basically a poor man's row creation timestamp. In Oracle SQL, I can do the following:

    CREATE TABLE FOO ( 
        ID NUMBER NOT NULL,  
        CREATED DATE DEFAULT SYSDATE NOT NULL );

So, whenever a row is inserted into the table, you don't need to set the 2nd column 
because it is automatically set with the date/time of when the insert occured. How 
would I do the equivalent of this in SQLite? I've tried everything with "date" and 
"now" that I could think of but no luck...

Thanks, 
Frank


                
---------------------------------
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.