I must be blind. Does anyone have a clue??
Thanks!!Code:SELECT DTE_SENT FROM DOCO.CORRESPONDENCE TO_DATE ('03-APR-2003','DD-MON-YYYY');
Printable View
I must be blind. Does anyone have a clue??
Thanks!!Code:SELECT DTE_SENT FROM DOCO.CORRESPONDENCE TO_DATE ('03-APR-2003','DD-MON-YYYY');
Your not blind, that's not correct syntax for Oracle!
What exactly are you trying to do?
Quote:
Originally posted by Kwj
I must be blind. Does anyone have a clue??
Thanks!!Code:SELECT DTE_SENT FROM DOCO.CORRESPONDENCE TO_DATE ('03-APR-2003','DD-MON-YYYY');
Maybe I'm blind, but it it doesn't look anywhere close to compiling.
Perhaps this is what you were thinking. I'm not sure what DTE_SENT is though.
Code:
SELECT DTE_SENT, TO_DATE ('03-APR-2003','DD-MON-YYYY')
FROM DOCO.CORRESPONDENCE ;
That was it, gandolf. Just a brain-sneeze on my end. Thanks everyone!!:D
Hmmmm :D and I thought you were infallable.Quote:
Originally posted by jovery
Your not blind, that's not correct syntax for Oracle!
What exactly are you trying to do?