[vwnc] SQLite Date fields

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[vwnc] SQLite Date fields

giorgiof
Hi, All,

I'm using the SQLite3  interface (latest from public store), but I have problems with Date fields. If I save a date field on the DB, it come back as a string and not as a date.
Am I missing something or this is an SQLite specific .. feature I don't know of?

thanks for any suggestion

Giorgio

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc
Reply | Threaded
Open this post in threaded view
|

Re: [vwnc] SQLite Date fields

Steven Kelly

SQLite doesn’t have a date type. See Q2 & 3 here:

http://www.sqlite.org/faq.html

 

HTH,

Steve

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of giorgio ferraris
Sent: 17 February 2009 14:03
To: [hidden email]
Subject: [vwnc] SQLite Date fields

 

Hi, All,

I'm using the SQLite3  interface (latest from public store), but I have problems with Date fields. If I save a date field on the DB, it come back as a string and not as a date.
Am I missing something or this is an SQLite specific .. feature I don't know of?

thanks for any suggestion

Giorgio


_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc
Reply | Threaded
Open this post in threaded view
|

Re: [vwnc] SQLite Date fields

giorgiof
Steve,
yes, I saw that, but it accept  a create table with a Date datatype, it seems, and I found some reference about using date fields, so I supposed sometime that datatype was added.

Thanks for the info,  I added support on my persistency framework (I have optional marshaling/unmarshaling) , so I bypassed this problem (thank to objects..)

ciao

Giorgio

On Tue, Feb 17, 2009 at 3:52 PM, Steven Kelly <[hidden email]> wrote:

SQLite doesn't have a date type. See Q2 & 3 here:

http://www.sqlite.org/faq.html

 

HTH,

Steve

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of giorgio ferraris
Sent: 17 February 2009 14:03
To: [hidden email]
Subject: [vwnc] SQLite Date fields

 

Hi, All,

I'm using the SQLite3  interface (latest from public store), but I have problems with Date fields. If I save a date field on the DB, it come back as a string and not as a date.
Am I missing something or this is an SQLite specific .. feature I don't know of?

thanks for any suggestion

Giorgio


_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc



_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc