asked on
Oracle trigger for the day name of the week
I am saving values to a table and I have a date that I need to get the DayOfWeek saved to another column. I want to do it in a proc or maybe in a trigger? I am not sure what the syntax is. I know in MySQL I can use DAYNAME('12/12/2103') and it would return Thursday but Im not sure what it is in Oracle.
Thanks
JK
Thanks
JK
DatabasesOracle DatabaseSQL
Last Comment
jknj72
to_char(sysdate,'fmDay')
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
If you are using 11g or above, I would look at using Virtual Columns.
These are derived when the column is selected and not permanently stored. Then you don't have to worry about triggers or procedures.
Check the example in the docs:
http://docs.oracle.com/cd/E11882_01/server.112/e25494/tables.htm#ADMIN11004
...
hrly_rate NUMBER(7,2) GENERATED ALWAYS AS (sal/2080),
...
hrly_rate is derived based on the sal column's value.
These are derived when the column is selected and not permanently stored. Then you don't have to worry about triggers or procedures.
Check the example in the docs:
http://docs.oracle.com/cd/E11882_01/server.112/e25494/tables.htm#ADMIN11004
...
hrly_rate NUMBER(7,2) GENERATED ALWAYS AS (sal/2080),
...
hrly_rate is derived based on the sal column's value.
I calculated 12/12/2103 to be a Wednesday. Did I do something wrong?
>>Did I do something wrong?
The typo of 2013?
The typo of 2013?
Why do you want to store the weekday in a column? This results in de-normalized data. Use a view (or virtual column) for this.
ASKER
I decided to split points with you two. Thank you both for your help.