Date in mmm yyyy format in postgresql

Question

I have a table with a column of type timestamp without time zone   I want to select that column with the mmm yyyy format     for example     Mar 2011      How to format it that way   I tried   select cast now   as date    but it is giving me the incorrect format

User · Answer

SELECT TO CHAR NOW     Mon YYYY

User · Answer

DateAndTime Reformat    SELECT    to char  last update   DD-MON-YYYY   as re format from actor       DEMO

User · Answer

You need to use a date formatting function for example to char http   www postgresql org docs current static functions-formatting html

User · Answer

I think in Postgres you can play with formats for example if you want dd mm yyyy  TO CHAR submit time   DD MM YYYY   as submit date

User · Answer

You can write your select query as   select   from table name where to char date time column   YYYY-MM       2011-03

[sql] Date in mmm yyyy format in postgresql

Examples related to sql

Examples related to postgresql