Re: [web2py] Storing date format in dd-mm-yyyy in database

[Ovidio Marinho]

      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
             ovidio...@gmail.com
               83   8826 9088 - Oi
             83   9334 0266 - Claro
                   Paraiba-Brasil



2011/10/11 Rohit <rohit.ba...@gmail.com>

> 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
>
>