Vinicius Assef <viniciusban@...> writes:
>
> 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 <ovidioccg@...> 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
> > ovidioccg@...
> > 83 8826 9088 - Oi
> > 83 9334 0266 - Claro
> > Paraiba-Brasil
> >
> >
> >
> > 2011/10/11 Rohit <rohit.bayar@...>
> >>
> >> 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
> >>
> >
> >
>
>
So in my application, say I will store date in
yyyy-mm-dd format and I need to
retrieve the date at several pages in my application
and I want to display the
date in dd-mm-yyyy, then
one option would be to use the strftime() method
in the view wherever I
display the date.
Because I retrieve the date at several pages
in the application storing date
in dd-mm-yyyy in database would have been
much easier for me.
Since its not possible.Is there any other easier solution to achieve it.
Rohit
