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

Login | Sign Up


	To Refer this Site to Your Friends Click Here

Categories >> Software >> MainFrame >> IBM MainFrame >> DB2

Question

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

Question Submitted By :: Guest

Rank

Answer Posted By

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

Answer
# 1

Data types are  DATE,TIME,TIMESTAMP

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

Is This Answer Correct ?

0 Yes

0 No

Question	Asked @	Answers
Other DB2 Interview Questions


The only place of VSAM KSDS in DB2 is?		2
What is the FREE command?		1
What is a root page?		1
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?		1
Is it possible to precompile if db2 goes down?	Target	4
What should be specified along with a cursor in order to continue updating process after commit?		1
What's the maximum number of volumes that can be added to a STOGROUP?		1
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?		3
can we drop column from a table	INDUS	4
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.	IBM	2
What is the difference between Where and Having Clause	iFlex	1
Which catalog table stores referential constraints?		1
what's the error code for Unique Index Violation?		2
I use CS and update a page. Will the lock be released after I am done with that page?		2
what is REORG? what is the use?		3
Can I use LOCK TABLE on a view?		1
What is referential integrity?		3
What is lock contention?		1
What is filter factor?		2
What is the difference between IN subselects and EXISTS subselect?	HCL	1

For more DB2 Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com