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

Is db2 free?

1134

What is the maximum number of columns in a db2 table?

1342

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

1165

What is catalog database in db2?

1214

Are views updateable?

1234

What do you mean by commit and rollback?

1087

What is node in db2?

1098

If I have a view which is a join of two or more tables, can this view be updateable?

1184

What are the 2 sqlcodes that are returned?

1232

Can we delete records from view?

1019

B37 abend during spufi?

1506

what is the responsibility of the construction superintendent

2209

What does db2 stand for?

1089

How to access db2 tables in mainframe?

1099

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

1219