How to convert dates to characters in oracle?
- 1 Answers
- 1124 Views
- I also Faced
- E-Mail Answers
Answer / Arvind Kumar Gupta
To convert dates to characters in Oracle, you can use the TO_CHAR function. Here is an example: SELECT TO_CHAR(your_date_column, 'DD-MON-YYYY') FROM table_name; This will convert your_date_column to a character string in the format DD-MON-YYYY.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
how to clone 9i Database on to 10g Database.
How to import one table back from a dump file?
difference between oracle8i and oracle9i
What is a system tablespace?
What is a private synonym?
What is a OUTER JOIN?
How to return top 5 rows in oracle?
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??
Write query to fetch second maximum salary from employee table.
4 Answers Bravura Solutions, HCL,
Why do we need oracle client?
What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?
Oracle General 
