Sign Up Login


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

How do we get current date in SQL Server 2000, Oracle, MS
Access?

Question Posted / honeysukumar

Answers were Sorted based on User's Feedback



How do we get current date in SQL Server 2000, Oracle, MS Access?..

Answer / abhirams

slect TO-CHAR(syssdate,'dd-mm-yy h:mipm') from dual; this is
oracle query..

Is This Answer Correct ?    5 Yes 8 No

How do we get current date in SQL Server 2000, Oracle, MS Access?..

Answer / smithers

select date() does not work in Access 97.

Is This Answer Correct ?    4 Yes 7 No

How do we get current date in SQL Server 2000, Oracle, MS Access?..

Answer / swetha

To display current systems date

DateTime.Now

Is This Answer Correct ?    2 Yes 18 No

Post New Answer

More SQL Server Interview Questions

Explain the database you used in your final year project?

0 Answers   Wipro,

How to list all schemas in a database?

0 Answers  

What is dimension table? : sql server analysis services, ssas

0 Answers  

How to Insert multiple rows with a single insert statement?

0 Answers  

Explain comment on transactions?

0 Answers  




What is always encrypted?

0 Answers  

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

0 Answers  

Why I am getting this error when dropping a database in ms sql server?

0 Answers  

How to return the second 5 rows in ms sql server?

0 Answers  

How can your resolve deadlocks?

4 Answers   IBM, IMS, Iron Mountain, NuWare,

Tell me about the approaches which you used to counter the DI problems.

0 Answers   EXL,

What are the instances when triggers are appropriate?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories