Thanks Den,
That is what we used but the parser doesn't like the ORACLE function
TO_DATE. You have to use the WMQI 'PASSTHRU" statement to get the parser to
ignore the statement and pass it to the ORACLE ODBC client. You have to play
with additionaal formatting functionality but it does work.

                   bobbee






From: "Miller, Dennis" <[EMAIL PROTECTED]>
Reply-To: MQSeries List <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: ESQL Oracle Date Conversion
Date: Tue, 31 Dec 2002 07:32:51 -0800

Don't know if there is anything special about doing it from a compute node
or how many bytes it occupies, but the SQL syntax to
insert  a standard Oracle date from a string is:

UPDATE table
SET column =TO_DATE(yourdate,'YYYYMMDD');



> -----Original Message-----
> From: Robert Broderick [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, December 30, 2002 12:29 PM
> To:   [EMAIL PROTECTED]
> Subject:           ESQL Oracle Date Conversion
>
> I want to convert an incoming date of YYYYMMDD to an Oracle 7 character
> standard date format. How do I do this in a Database Insert statement in
a
> compute node.
>
>                       Bobbee
>
>
>
>
>
> _________________________________________________________________
> STOP MORE SPAM with the new MSN 8 and get 3 months FREE*.
>
http://join.msn.com/?page=features/junkmail&xAPID=42&PS=47575&PI=7324&DI=7474&SU=
>
http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_stopmorespam_3mf
>
> Instructions for managing your mailing list subscription are provided in
> the Listserv General Users Guide available at http://www.lsoft.com
> Archive: http://vm.akh-wien.ac.at/MQSeries.archive

Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://vm.akh-wien.ac.at/MQSeries.archive

_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://vm.akh-wien.ac.at/MQSeries.archive

Reply via email to