Clarifying, date fields are stored in internal format and they are optimized for that.
You can customize representation format, not stored format. It was what Ovidio showed you. -- Vinicius Assef. On Tue, Oct 11, 2011 at 10:16 PM, Ovidio Marinho <[email protected]> wrote: > > in db > Field('start_time','datetime',requires=IS_DATETIME(str(T('%Y-%m-%d > %H:%M:%S')))), > Field('stop_time','datetime',requires=IS_DATETIME(str(T('%Y-%m-%d > %H:%M:%S')))), > > db.task.start_time.represent = lambda v: v.strftime('%d/%m/%Y') > db.task.stop_time.represent = lambda v: v.strftime('%d/%m/%Y') > is this > in view: > > <td>{{=task.start_time.date().strftime('%d-%m-%Y')}}</td> > <td>{{=task.stop_time.date().strftime('%d-%m-%Y')}}</td> > ok? > > > Ovidio Marinho Falcao Neto > [email protected] > 83 8826 9088 - Oi > 83 9334 0266 - Claro > Paraiba-Brasil > > > > 2011/10/11 Rohit <[email protected]> >> >> I am developing an online booking application where >> I am storing the date using the date type of >> web2py which stores the date in yyyy-mm-dd format. >> I need to store the data in dd-mm-yyyy format in >> the datastore. >> >> For this I tried to use this : >> date.requires = IS_DATE(format=T('%d-%m-%Y') >> >> Though it takes the date in dd-mm-yyyy format >> it does not store in the dd-mm-yyyy format.It still >> stores in yyyy-mm-dd format >> >> Please provide suggestion >> >> Thanks >> > >
