In my table I have a column as storage_date with value as 16-09-2022 and I need to create 3 columns as YEAR,MONTH,DAY in same table and I want to load data for these three columns from storage_date column as 2022 for YEAR , 09 for MONTH and 16 for DAY
1 Answers
Assuming its Oracle DB this should work:
update tbl set dd = extract(day from storage_date), yyyy = extract(year from storage_date), mm = extract(month from storage_date)
From the docs https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions050.htm
Related