CODEWITHSUNDEEP
pythondatabasedateweb2py
Agustin.Ferreira
Agustin.Ferreira

Reputation: 311

Formatting date in Web2py Python

I'm looking for a function to format a date in order to get day, month and year. Dates are being stored in my database in the following format 2012-09-26.

Upvotes: 4

Views: 4327

Answers (1)

Bruno Rocha - rochacbruno
Bruno Rocha - rochacbruno

Reputation: 8168

If your goal is to display on web2py template, so you have to use pure Python to format

{{=row.datetime_field.strftime("%d/%m/%Y")}}

The above will generate 25/09/2012

Tale a look at Python strftime documentations.

If you want to show only the day.

{{=row.datetime_field.date}}

Also you can set it as a representation for that field

db.mytable.datetime_field.represent = lambda value, row: value.strftime("format-here")

The representation will be useful only on SQLFORM.grid and SQLTABLE

All you need is strftime

Upvotes: 11

Related Questions