Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sujit pingale
select to_char(sysdate, 'day') from dual;
This will print output: tuesday i.e
select last_day(sysdate) from dual;
This will print output: 31-Aug-14
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Why do we use joins in sql?
What is assignment operator in pl sql?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is union?
What is mdf ldf and ndf?
What is materialized view in sql?
How does sql profiler work?
Can a key be both primary and foreign?
how to drop an existing view in mysql? : Sql dba
What is the difference between the conventional and direct path loader? : aql loader
What is difference between procedure and trigger?
What are keys in sql?
How can you save or place your msg in a table?
How to start the command-line sql*plus?
how to enter numeric values as hex numbers? : Sql dba
