I'm trying to extract some data to files to insert into an
oracle table and I'm having difficulty in getting the date
formatted so that oracle can read it. How do I get a date
out of SQL Server so that it will conform to dd-mon-yyyy
and Oracle won't cough and sputter?

Don't know what Oracle will accept but you can use CONVERT() to format the
date into any kind of string you wish. Specifically the 130 option sounds
like what your after. Check out CONVERT() in BooksOnLine.

--
Andrew J. Kelly SQL MVP


"Ptaz" <ptaz (AT) comcast (DOT) net> wrote