Combine Oracle day month year as a date

hello
i have table has 3 fileds
fd (day)
fm (month)
fy (year)

 how to combine them all to make as date
NiceMan331Asked:
Who is Participating?
 
sdstuberCommented:
select to_date(fy||'-'||fm||'-'||fd,'yyyy-mm-dd') your_date from your_table

This assumes your fields are all numeric, or text of numeric values.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.