Assuming data is being stored in a DB2 TIMESTAMP

what is the equivalent of Oracle's to_date function :

to_date('03/04/2005','MM/DD/YYYY')

It's OK if MM/DD/YYYY is the only supported format.

Thanks.

<gimme_this_gimme_that@yahoo.com> wrote in message
news:1115661500.329963.49930@z14g2000cwz.googlegro ups.com...[color=blue]
> Assuming data is being stored in a DB2 TIMESTAMP
>
> what is the equivalent of Oracle's to_date function :
>
> to_date('03/04/2005','MM/DD/YYYY')
>
> It's OK if MM/DD/YYYY is the only supported format.
>
> Thanks.
>[/color]
What does the Oracle to_date function do? Remember, we're mostly DB2 users
here. Although there are some people that know DB2 *and* Oracle, many of us
don't know Oracle at all. However, we *can* find things in the DB2 manuals
fairly easily, such as descriptions of functions. If you give us a short
description of what 'to_date()' does, we can point you to the closest DB2
equivalent(s).

It would also help if you mentioned which operating system and version of
DB2 you are using; the functions available on each OS are largely the same,
especially in the current versions of DB2, but if you are using older
versions, some functions that we might want to suggest may not be available
in that version.

Rhino

Hi Rhino,

Thanks very much for your response and the tips.

The answer to my question (the equivalent of
to_date('03/04/2006','MM/DD/YYYY') )

ended up being :

timestamp(date('03/04/2005','00.00.00'))

In other words, I needed to get a MM/DD/YYYY formatted
date into a TIMESTAMP field.