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

How to find out the list schema name and table name for the database?

0 Answers  

can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?

1 Answers  

What is create command?

0 Answers  

What is the security model used in sql server 2005?

0 Answers  

How many types of database relationship in sql server?

0 Answers  




how we can store the value like that 001,003,023 etc in sql server 2005

7 Answers  

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

0 Answers  

What is an identity column in insert statements?

0 Answers  

Define inner join in sql server joins?

0 Answers  

What is the meaning of resultset type_scroll_insensitive?

0 Answers  

Explain raiserror in sql server?

0 Answers  

Explain what is the difference between union and union all?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories