[sqlite] create table default expr

Hi I want to (if possible) create a table with a default timestamp in a format other than -MM-DD ... per example below. I have tried a few variants but always get same error. Can this be done and if so, how? create table ( custnum integer primary key not null, note text,

Re: [sqlite] create table default expr

2008/11/3 John [EMAIL PROTECTED]: Hi I want to (if possible) create a table with a default timestamp in a format other than -MM-DD ... per example below. I have tried a few variants but always get same error. Can this be done and if so, how? create table ( custnum integer

Re: [sqlite] create table default expr

John [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I want to (if possible) create a table with a default timestamp in a format other than -MM-DD ... per example below. I have tried a few variants but always get same error. Can this be done and if so, how? create table (

Re: [sqlite] create table default expr

Simon Davies wrote: 2008/11/3 John [EMAIL PROTECTED]: Hi I want to (if possible) create a table with a default timestamp in a format other than -MM-DD ... per example below. I have tried a few variants but always get same error. Can this be done and if so, how? create table (

Re: [sqlite] create table default expr

Igor Tandetnik wrote: John [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I want to (if possible) create a table with a default timestamp in a format other than -MM-DD ... per example below. I have tried a few variants but always get same error. Can this be done and if so,