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

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

Question Posted / abhirams

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

Please Help Members By Posting Answers For Below Questions

What is difference between rownum and row_number?

954

Why variables called the most powerful component of ssis?

1066

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1116

Does table partitioning improve performance?

956

Explain hostprotectionattribute in sql server 2005?

1006

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1163

How to connect to SQL Azure Database by using sqlcmd?

136

What is query optimizer in sql server?

1008

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1203

What is a non-clustered index?

989

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

1066

Explain the benefits of user-defined functions?

1047

What is the difference RDBMS and Graph Database?

1041

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

921

Can you explain what are commit and rollback in sql?

927