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

What are the three DB2 date and time data types and their
associated functions?

Answer Posted / s

Data types are DATE,TIME,TIMESTAMP

A few of the functions are
DATE
HOUR
MONTH
SECOND
TIME
TIMESTAMP

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a corelated subquerry?

1122


What is cursor with hold option in db2?

1072


Why do we need reorg in db2?

986


How many databases can be created inside an instance in db2 ?

1035


List down the types of triggers in the db2 database?

1027


What is blu acceleration in db2?

1069


Explain what are the various isolation levels possible?

1044


What is the cobol picture clause of the db2 data types date, time, timestamp?

1067


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1146


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1437


Where do you specify them?

1279


What are bind parameters in db2?

1046


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

1102


What is a bind in db2?

1042


How to retrieve rows from a db2 table in embedded sql?

1390