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 are the database objects? : SQL Server Architecture

562

What is identity?

573

What is bit data type?

638

Difference between LEN() and DATALENGTH() in sql server ?

611

Delete duplicate rows without using rowid.

1088

What is user-defined multi-statement table-valued function?

663

What is a subquery in a select query statement in ms sql server?

603

How to list all user names in a database?

599

What is the default port for SQL Server over a firewall?

600

What are joins in sql and what are the different types of joins?

562

What is dbcc?

744

What is an indexing technique?

505

Explain how to integrate the ssrs reports in application?

534

Explain the difference between HTTP and HTTPS in database?

572

What is resource governor in sql server?

571