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

How can you display the current date & current time ?

Answer Posted / raghu

select currentdate,currenttime from sysibm.sysdummy
the above date and time are scalar functions and it from the timestamp

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many databases are there?

1048


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2386


What are packages in db2?

1019


Can you use max on a char column?

1091


What do you mean by storage group (stogroup)?

1037


What is the syntax for FETCH in DB2 ?

1203


What is the latest version of ibm db2?

1263


How and when does the db2 enforces the unique key?

1079


What is a plan and package in db2?

1093


Is db2 relational database?

971


What is data manager?

1042


What is db2 catalog database?

1034


Is db2 free?

1089


What is reorg?

1151


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1155