<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><DIV><DIV>On 06/02/2007, at 13:07 , <<A href="mailto:John.Hockaday@ga.gov.au">John.Hockaday@ga.gov.au</A>> wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">The trouble is that the LASTUPDATE date (Oracle RDBMS) is in the form</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">DD-MON-YYYY<SPAN class="Apple-converted-space"> </SPAN>whereas I want ISO 8601 format like YYYY-MM-DD.</DIV></BLOCKQUOTE><BR></DIV><DIV>By the time you get it, you've got a string like '12-Mar-2004', is that right?</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>My suggestion would be to find out how to get the data from Oracle in the form that you want - if this is under your control, all well and good :) I don't know Oracle (despite being trained on in about 15 years ago), but under PostgreSQL you'd do this:</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>select <FONT class="Apple-style-span" face="Courier" size="3"><SPAN class="Apple-style-span" style="font-size: 13px;">to_char(lastupdate, 'YYYY-MM-DD'), ... from ...</SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" face="Courier" size="3"><SPAN class="Apple-style-span" style="font-size: 13px;"><BR class="khtml-block-placeholder"></SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" face="Courier" size="3"><SPAN class="Apple-style-span" style="font-size: 13px;">HTH</SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" face="Courier" size="3"><SPAN class="Apple-style-span" style="font-size: 13px;">alex</SPAN></FONT></DIV></BODY></HTML>