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

Exec sql
set :ws-current-date to current date
End exec

display 'current date' ws-current-date.



Exec sql
set :ws-current-time to current time
End exec

display 'current time' ws-current-time.

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the syntax for FETCH in DB2 ?

1264


what are bind concepts in db2 cobol?

1137


What is dpf in db2?

1167


What is the maximum length of sqlca?

1608


What is performance tuning db2?

1109


What is the use of reorg in db2?

1137


What is ibm db2 used for?

1127


Explain package in db2 and its advantages?

1269


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2155


Mention the various locks that are available in db2.

1080


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3202


How to rename a table in DB2 ?

1145


What are the contents of a dclmgen?

1176


Which isolation level provides maximum concurrency?

1203


What is a db2 collection?

1106