1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is the use of time stamp in select statement?

Question Posted / nishi.swain


What is the use of time stamp in select statement?..

Answer / parthasarathi

timestamp is used to store dates along with time .. we can store hours , minutes, seconds and milli seconds.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Can we insert delete data in view?

0 Answers  

The select into statement is most often used to create backup copies of tables or for archiving records?

0 Answers  

select 1,col1,col2 from table1. output?

5 Answers   Ramco,

What is bind variable in pl sql?

0 Answers  

Can a varchar be a primary key?

0 Answers  




Explain the purpose of %type and %rowtype data types?

0 Answers  

what is a cursor

9 Answers   IBM, TCS, Wipro,

how to get a list of indexes of an existing table? : Sql dba

0 Answers  

what is global variable in package

3 Answers   Polaris,

How can we find duplicate records in a table?

0 Answers  

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

How show all rows in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories