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

Is the order of columns in the set clause important in ms sql server?

926

what is a schema in sql server 2005? : Sql server database administration

957

Does group by or order by come first?

900

what is sql server? : Sql server database administration

928

How to write character string constants or literals in ms sql server?

958

How to make a column nullable?

1038

What are wait types?

1019

Detail about the hardware which is supported by SQL server?

1009

How dts is used to extract, transform and consolidate data?

1021

why would you use sql agent? : Sql server database administration

1115

what are triggers? : Sql server database administration

863

What is temporal table?

824

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2027

Mention the 3 ways to get a count of the number of records in a table.

917

Explain difference between cross join and full outer join?

953