By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,779 Members | 1,078 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,779 IT Pros & Developers. It's quick & easy.

Equivalent of Oracle's to_date('03/04/2005','MM/DD/YYYY')

P: n/a
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.

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

<gi*******************@yahoo.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...
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.

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
Nov 12 '05 #2

P: n/a
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.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.