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 a storage group (stogroup)?

1248


before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2182


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2535


What is the use of dclgen in db2?

1085


Define db2.

1120


What is ibm db2 client?

944


What is dclgen (declaration generator)?

1063


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2218


Is ibm db2 open source?

1078


What is the reason behind not using select * in embedded sql programs?

1118


What is database alias db2?

1132


What is the maximum length of sqlca?

1531


What is meant by dclgen?

1113


What is view db2?

1082


How do I delete a column in db2?

1112