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

Answer Posted / abhirams

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

Is This Answer Correct ?    5 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between delete & truncate commands?

733


What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

833


how to do partition in sqlserver

2146


What are the difficulties faced in cube development? : sql server analysis services, ssas

798


What is an expression in ms sql server?

725






What are xml indexes?

699


You want to use a perspective in an mdx query. How do you select the perspective?

185


How to select some specific columns from a table in a query in ms sql server?

721


How many types of keys are there?

740


what is database replication? : Sql server database administration

715


What is use of except clause? How it differs from not in clause?

757


What is the definition for sql server 2000?

790


Please differentiate between a local and a global temporary table?

755


What is the guest user account in sql server? What login is it mapped to it? : sql server security

762


Tell me something about security and sql azure?

112