There are four types of time formats in DB2:
ISO-YYYY-MM-DD HH.MM.SS
USA-MM/DD/YYYY HH:MM(AMor PM)
EUR-DD.MM.YYYY HH.MM.SS
JIS-YYYY-MM-DD HH:MM:SS
Indexed columns, you can’t use in Built in functions.
For instance,
DATE(B.T_TIMESTAMP) < :WSDATE
You can give like this:
T_TIMESTAMP< TIMMESTAMP(:WSDATE,’00.00.00′).
DATE and TIME are both CHAR. The default is ISO format is YYY-MM-DD HH.MM.SS. If you want you can change this format.
Keep Reading
Srinimf 