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

Reply via email to