select TIMESTAMP(DATECOLUMN) FROM TABLE1

What is query for your birthday date should be in hours,minute
and seconds format?

Question Posted / saikishore

Answer Posted / saikishore

select TIMESTAMP(DATECOLUMN)
FROM TABLE1

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the use of with ur in db2?

1004

Comment whether the cursor is closed during commit or not.

1042

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

1086

List down the types of triggers in the db2 database?

965

Can we delete records from view?

916

What is a plan and package in db2?

1048

How can deadlocks be resolved?

889

Explain package in db2 and its advantages?

1138

What are db2 tables?

1053

What is runstats utility in db2?

963

What is the purpose of rollback and commit?

1089

what is the role of the cursor in db2?

1002

How do I delete a table in database?

977

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11618

Explain the contention situations caused by locks?

1014