yyyy from timestamp

[Prakash]

Hi

Can anyone tell me how to derive "yyyy" from a timestamp column in
db2? Something like to_char(sysdate, 'yyyy') ... in oracle. I have to
oracle-like to_char function but its very slow.

If the column is DATE then I can use char(date, USA) and then substr
of 'yyyy', but I am not sure how can I do this with timestamp.

Please help

Thanks

V Prakash

[Mark A]

"Prakash" <ve***********@hotmail.com> wrote in message
news:78**************************@posting.google.c om...

Hi

Can anyone tell me how to derive "yyyy" from a timestamp column in
db2? Something like to_char(sysdate, 'yyyy') ... in oracle. I have to
oracle-like to_char function but its very slow.

If the column is DATE then I can use char(date, USA) and then substr
of 'yyyy', but I am not sure how can I do this with timestamp.

Please help

Thanks

V Prakash

You can download PDF versions of the manual here:
www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8pubs.d2w/en_m
ain

You want the SQL Reference.

Look at the YEAR function

[No Body]

Prakash wrote:

Hi

Can anyone tell me how to derive "yyyy" from a timestamp column in
db2? Something like to_char(sysdate, 'yyyy') ... in oracle. I have to
oracle-like to_char function but its very slow.

If the column is DATE then I can use char(date, USA) and then substr
of 'yyyy', but I am not sure how can I do this with timestamp.

Please help

Thanks

V Prakash

Hi V, you can use year function to do that. Something like year(sysdate)
will give a integer value of the year.

[Prakash]

Thank you all.

V Prakash

[Stefan Kraemer]

Look at this: ( DB2 Basics: Fun with Dates and Times )
http://www-106.ibm.com/developerwork.../0211yip3.html
I guess it´s more than what you expect.

Cheers
Stefan

--
IT Consulting Stefan Krämer
D-88682 Salem
http://www.skc-group.com
Prakash schrieb:

Hi

Can anyone tell me how to derive "yyyy" from a timestamp column in
db2? Something like to_char(sysdate, 'yyyy') ... in oracle. I have to
oracle-like to_char function but its very slow.

If the column is DATE then I can use char(date, USA) and then substr
of 'yyyy', but I am not sure how can I do this with timestamp.

Please help

Thanks

V Prakash