Sqlite does not have a DATETIME type. It stores the decalred type but
ignored it. You can use it in your application.
Rael Bauer wrote:
> Hi,
>
> If I declare a field as DATETIME default "2001-01-01", ( e.g. alter table
> "notes" add column "last_modified" DATETIME default "2001-01-01";) wil
Hi,
If I declare a field as DATETIME default "2001-01-01", ( e.g. alter table
"notes" add column "last_modified" DATETIME default "2001-01-01";) will the
declared default value be stored as a string or real value?
Also, more generally, how can I find out what storage type field values have
been s
On Mon, 27 Jul 2009, Rael Bauer wrote:
> If I declare a field as DATETIME default "2001-01-01", ( e.g. alter table
> "notes" add column "last_modified" DATETIME default "2001-01-01";) will
> the declared default value be stored as a string or real value?
Rael,
What you have above is data type
On Mon, 27 Jul 2009, Rael Bauer wrote:
> If I declare a field as DATETIME default "2001-01-01", ( e.g. alter table
> "notes" add column "last_modified" DATETIME default "2001-01-01";) will
> the declared default value be stored as a string or real value?
Rael,
String (the actual data storage
On Mon, Jul 27, 2009 at 4:45 PM, Rael Bauer wrote:
> Hi,
>
> If I declare a field as DATETIME default "2001-01-01", ( e.g. alter table
> "notes" add column "last_modified" DATETIME default "2001-01-01";) will the
> declared default value be stored as a string or real value?
>
string
> Also, mor
Hi,
If I declare a field as DATETIME default "2001-01-01", ( e.g. alter table
"notes" add column "last_modified" DATETIME default "2001-01-01";) will the
declared default value be stored as a string or real value?
Also, more generally, how can I find out what storage type field values have
b
6 matches
Mail list logo