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

What is meant by explain?

1083


How would the varchar column remarks defined?

1046


What is alias in db2?

1011


How do you select a row using indexes in db2?

1087


How do you eliminate duplicate values in db2?

1124


How to test SQL -911 error while developing COB-DB2 program

7479


Which command is used to connect to a database in DB2 ? Give the Syntax.

1053


Define buffer pool.

1008


What is meant by dclgen?

1074


What is sqlca’s maximum length?

1119


What is database manager in db2?

980


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2197


How do I delete a table in database?

995


What is the use of with ur in db2?

1016


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3541