I have created a table with a field Register_Date in DATE format. However, it results showed me 21/12/2008
I would like to change it to 21/Dec/2008
How do I change that using SQL command? I tried to Google and used codes like below and it will not work
SELECT CONVERT( CHAR(6), Register_Date, 106 )
FROM REG
The error message was ORA-00936: missing expression
I also tried:
SELECT replace(convert(char(15),Register_Date,106),' ',' - ')
FROM REG
and it gives it the same error message.
Any suggestions?
Thanks