How to convert a string to a date in oracle database?
Answer / Virendra Sharma
To convert a string to a date in Oracle Database, you can use the TO_DATE function. For example: TO_DATE('2022-01-01', 'yyyy-mm-dd'); This will convert the string '2022-01-01' into a date.
| Is This Answer Correct ? | 0 Yes | 0 No |
Please explain oracle data types with examples?
What is a nvl function?
What happens if you set the sga too low in oracle?
find out first highest salary?
10 Answers Verinon Technology Solutions,
what are views?
What are the various oracle database objects?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
What are the sql clauses supported in the link property sheet ?
hai, I am searching job on Oracle10g and PL/sql,Unix... can any one send me resume format. an suggest me how to prepare.. ann books..
What is Hash Index?
How can we find out the duplicate values in an oracle table?