Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can SSRS reports Cache results?

151

What is the sql case statement used for? Explain with an example?

1002

Is the primary key column of a table an index in ms sql server?

966

Explain partitioned view?

1095

What is trigger and different types of Triggers?

1154

What is sleeping status in sql server?

1030

What are temporal tables in sql server 2016?

892

What the difference between UNION and UNIONALL?

1047

Explain indexed views and partitioned view with their syntax.

1151

How to create a new schema in a database?

1161

Can a cursor be updated? If yes, how you can protect which columns are updated?

1118

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

964

Can I work with several databases simultaneously? : sql server management studio

998

Will sql server 2005 allow you to reduce the size of a column?

1002

what happens on checkpoint? : Sql server database administration

1113