How do we get month name in SQL Server 2000, Oracle, MS Access?
Answer Posted / kathiravan jayachandran
In Oracle
select to_char(sysdate, 'dd/mm/yyy')as year from dual
EG:-
select ed.emp_date_of_birth,ed.first_name,ed.last_name
from emp_details ed where
to_char(ed.emp_date_of_birth,'mm')=to_char(sysdate,'mm')
Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
What stored by the model?
Can you use order by when defining a view?
What is a with(nolock)?
What are the new security features added in sql server 2012? : sql server security
How to update a field in SQL after ALTERING a row?
How to change the name of a database user?
Where cross join is used?
What is difference between createstatement and preparedstatement?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
How do triggers work?
What is constraints and its types?
What is de-normalization in sql database administration? Give examples?
How to move database physical files in ms sql server?
What is indexed view?