How to display the days of the week?

hi, I want to calculate the days of the week from a data column that stores date information.

thank you

Best Answer

HI：      In Finereport，you can use formula WEEKDAY to get the date and returns the number of weeks      More details you can refer to this document：https:// ...

• Seigann
• Published on2020-07-31
• Detailed Answer>>

HI：

     In Finereport，you can use formula WEEKDAY to get the date and returns the number of weeks
     More details you can refer to this document：https://help.finereport.com/doc-view-819.html#49

In postgresql you can use :

extract(dow from datefield) as day_of_week

That gets you the number between 0 and 6 (0=sunday). If that is what you need?