I think something is wrong in your model. If a field is declared of
type 'date' or 'datetime', web2py generates the SQL with the to_date
(..) function. I think you may have incorrectly defined the Field
('timestamp') as a string. BTW. I do not think 'timestamp' is a valid
field name since it is a reserved keyword.On Nov 19, 5:47 am, Gabriele Alberti <[email protected]> wrote: > Hello web2py users, > I defined a table with one of the fields as datetime type, and when I > try to insert a raw it fails with this > > ORA-01830: date format picture ends before converting entire input > string > > with a raw query looking like this > > INSERT INTO vals(timestamp, value, type, number) VALUES ('2009-09-07 > 12:00:00', 24, 11, 1); > > which works with a MySQL backend. > Googling a bit it turns out its a problem of datetime conversion in > oracle. > Im still investingating about this, but what I get so far is the > default Oracle DATE format is something weird (kind of YYYY-MM-DD, no > hour and so). > To fix the problem you can either do this to change it to our (python > datetime) format > > alter session set NLS_DATE_FORMAT='<my_format>'; > > but this lasts just for this session, or use something like > > INSERT INTO vals(timestamp, value, type, number) VALUES (to_date > ('2009-09-07 12:00:00', 'yyyy-mm-dd hh:mi:ss'), 24, 11, 1); > > using the to_date() oracle function. > > I did not yet try anything of this solutions, and anyway I guess we > need a web2py fix.. any other hint ? > > Thanks, --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
