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
