Date Format

jduran1888 · March 18, 2016, 10:00am

I have this date 10/12/1959 and I need to show it as October 1959. Can you show me an example on how to format this date correctly the way I need it to show?

jduran1888 · March 18, 2016, 11:02am

Nevermind my question as I found the answer:

TO_CHAR(date, ‘fmMonth YYYY’)

Topic		Replies	Views
Number to date DDMMYYYY Toad for Oracle	4	4806	December 26, 2018
Date Format issue with Toad 10.6.1 Toad for Oracle	1	1210	April 4, 2012
12.5 Formatter issue.. Toad for Oracle	0	359	June 19, 2014
Format for date query Toad for Oracle	14	16087	October 18, 2017
From varchar to date format mm/dd/yyyy Toad for Oracle	12	7483	April 6, 2011

Date Format

Related topics