Sorry I didn't get back sooner on this, but SQLite doesn't have a datetime field, so django fakes it by using a string type there, but giving making it look like a date in django. My mistake. See documentation here: http://www.sqlite.org/datatype3.html
On May 7, 11:46 am, Greg <[EMAIL PROTECTED]> wrote: > Cliff, > I just looked at my table and the type is varchar(100). Not sure why > the type is a varchar when the field is a DateTime. I tried changing > the table but wasn't able to change the type to date. I'll brush up > on my SQL and hopefully be able to change the type. I'll let ya know. > > Thanks > > On May 7, 10:25 am, "J. Cliff Dyer" <[EMAIL PROTECTED]> wrote: > > > On Wed, 2008-05-07 at 07:37 -0700, Greg wrote: > > > Karen, > > > Here is the error that I'm getting: > > > > // > > > Enter a valid date in YYYY-MM-DD format. > > > // > > > > I'm using SQLite > > > Go into the database shell using `manage.py dbshell` and type `PRAGMA > > TABLE_INFO(your_table_name);`. If you're unsure what your table is > > named, you can find it from the shell with `.tables` (no semicolon). > > > Make sure the database is using the correct column type for your date > > field. For sqlite this should be "datetime" or just "date". > > > Cheers, > > Cliff --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---