substr function on timestamp datatype

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

db2_d_b_a - 18 Dec 2006 03:52 GMT

Hi all,

does the substr function work with timestamp datatype columns. I wanted
to use it for padding the various columns for a report. I can live
without it :) .. though just wanted to know if it works with the
timestamp data type.

cheers,

Reply to this Message

Serge Rielau - 18 Dec 2006 14:58 GMT

> Hi all,
>
[quoted text clipped - 4 lines]
>
> cheers,

Convert the timestamp to a char, then substr.
Also note that DB2 provides functions such as DAY(), MONTH() etc. to
extract pieces from a timestamp.

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Forum2006/Forum2006.html

Reply to this Message