Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Conversion
Tally wrote:
> Hi,
>
> Is it possible to convert the byte array(Unsigned 32 bit integer
> value, with bytes reversed to sort properly) to Date type using oracle
> PL/SQL or other tools?
>
> Thanks a lot !
>
> Best Regards,
> Tally
Not sure exactly what you are asking but try:
SELECT REVERSE(value) FROM dual;
And see if it does what you want.
-- Daniel Morgan http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Mon Jul 21 2003 - 10:42:21 CDT