adspace


  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

Can we convert a date to char in oracle and if so, what would be the syntax?

Question Posted / Vitesh Kumar

Answer Posted / Vitesh Kumar

"Yes, you can convert a date to character in Oracle using the TO_CHAR function. Here is an example:nnSELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') FROM dual;"

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle latest version?

1174

How to select all columns of all rows from a table in oracle?

1132

How to put more than 1000 values into an oracle in clause?

1115

Design database draw er diagram for a certain scenario ?

4656

How to start an oracle instance?

1103

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1956

How to write a left outer join with the where clause in oracle?

1156

How to use values from other tables in update statements using oracle?

1158