DB2 four types of Time Formats

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 cannot be used in Built in functions. For instance, DATE(B.T_TIMESTAMP) < :WSDATE

You can give like this: T_TIMESTAMP< TIMMESTAMP(:WSDATE,’00.00.00′).

You know that DATE and TIME are both CHAR. The default is ISO format. YYY-MM-DD  HH.MM.SS. But, if you want you can change this format.

Great knowledge!!

Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.