Tuesday, 1 March 2011

Day of the week, Day of the week for previous day in Oracle

select to_char(to_date('15-09-2010','dd-MM-yyyy'),'D') from dual; -- day of week for a date

select to_char(to_date('15-09-2010','dd-MM-yyyy')-1,'D') from dual; -- day of week for a date before

No comments:

Post a Comment

Executive Summary: Anthropic's Claude Mythos Model

  What Happened Anthropic announced  Claude Mythos Preview , a new AI model it describes as its most capable ever — and so powerful in cyber...