Oracle handles DATE type similarly to DATETIME so it outputs date with
timestamp 00:00:00. If you print out SQLRow you will see that it
contains datetime.datetime(2009, 4, 6, 0, 0)
But for portablility it should be datetime.date(2009, 4, 6, 0, 0)
I could not identify correct place to patch in gluon/sql.py myself.
model:
db.define_table('details',
SQLField('header', db.headers),
SQLField('ca_date', 'date'),
...
)
Resulting SQL SELECT and its output:
SELECT details.ca_date FROM (SELECT w_tmp.*, ROWNUM w_row FROM (SELECT
details.c
a_date FROM details ORDER BY details.ca_date DESC) w_tmp WHERE
ROWNUM<=1) detail
s WHERE w_row > 0;
details.ca_date
2009-04-06 00:00:00
<SQLStorage {'ca_date': datetime.datetime(2009, 4, 6, 0, 0)}>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
