I could use some assistance please with formatting the date in the output of an SQL query. I am able to do what I want, (change column names,etc), but somehow, I am not having much luck on the formatting side. Using the replace function, from what I was able to locate, gave me the closest results. I want to change the format of one column from mm/dd/yyyy to yyyy/mm/dd. What I'm getting is dd-JUN-yy. The column I want to format is 'Name of Period'.
select distinct scv_course_act.course_id as "Course Number",scv_course_act.off
ering_id as "Section ID", scv_course_act.title as "Course Name",
crafts.nm_cft as "Department Name",replace (scv_course_act.start_date
mdd') as "Name of Period",
null as "Year",scv_instr_assign.pe
rson_no as "Instructor Identifier",null as "Course Designation",
scv_course_act.domain as "Course Type", null as "Program",null as "Cross-list Code",null as "University Code",scv_course_act.start
_date as "Start Date", scv_course_act.end_date as "End Date"
where scv_course_act.start_date between to_date ('2010/12/31','yyyy/mm/dd'
) and to_date ('2013/01/01','yyyy/mm/dd'
I've also tried yyyyMmDd in the format, thinking that would help. It did not.
thank you for your assistance