Data types are DATE,TIME,TIMESTAMP A few of the functions are DATE

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

Question Posted / s

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

Please Help Members By Posting Answers For Below Questions

Who uses db2?

1054

What is with ur in db2?

1322

What is the connection string to connect to the DB2 Database ?

1135

What is a bind card?

1222

What is catalog database in db2?

1172

What do you mean by between and in? Is between inclusive of specified range values?

1092

What's The Percentage Free Space ?

1227

What is the difference between db2 and oracle?

1135

What is package in cobol db2?

1120

Are view updateable?

1050

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

2219

How do I import data from excel to db2?

1077

What is host variable in db2 cobol?

1082

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

3157

How to execute stored procedure in db2 command editor?

1052