---
title: "How to convert different string formats into date in oracle?"  
description: "How to convert different string formats into date in oracle?"  
author: "Utpal Vishwas"  
published: 2023-07-17  
updated: 2023-07-18  
canonical: https://www.mindstick.com/forum/159140/how-to-convert-different-string-formats-into-date-in-oracle  
category: "oracle"  
tags: ["database", "string", "oracle"]  
reading_time: 2 minutes  

---

# How to convert different string formats into date in oracle?

How to [convert](https://www.mindstick.com/forum/2093/configurationmanager-appsettings-convert-n-to-n-why) different [string](https://www.mindstick.com/articles/1527/string-split-in-c-sharp) [formats](https://www.mindstick.com/forum/160705/explain-the-concept-of-datetime-formats-in-c-sharp) into [date](https://yourviews.mindstick.com/story/3869/propose-day-2024-exciting-date-ideas-for-you-and-your-partner) in [oracle](https://www.mindstick.com/articles/13016/alter-table-statement-or-command-in-oracle)?

## Replies

### Reply by Aryan Kumar

To convert different string formats into date in Oracle, you can use the `TO_DATE()` function. The `TO_DATE()` function takes two arguments: the string to convert and the date format. The date format is a string that specifies the format of the string to convert.

For example, the following code converts a string in the format "DD-MM-YYYY" to a date:

SQL

```plaintext
SELECT TO_DATE('2023-07-18', 'DD-MM-YYYY');
```

This code would return the date `2023-07-18`.

Here is a table of some of the common date formats that you can use with the `TO_DATE()` function:

| Date Format | Description |
| --- | --- |
| `DD-MM-YYYY` | The day, month, and year in the format "DD-MM-YYYY". |
| `YYYY-MM-DD` | The year, month, and day in the format "YYYY-MM-DD". |
| `MM/DD/YYYY` | The month, day, and year in the format "MM/DD/YYYY". |
| `DD Mon YYYY` | The day, month abbreviation, and year in the format "DD Mon YYYY". |

You can also use the `TO_DATE()` function to convert a string in a custom format to a date. For example, the following code converts a string in the format "YYYYMMDD" to a date:

SQL

```plaintext
SELECT TO_DATE('20230718', 'YYYYMMDD');
```

This code would also return the date `2023-07-18`.

The `TO_DATE()` function is a powerful tool that you can use to convert different string formats into dates in Oracle. By using the `TO_DATE()` function, you can ensure that your dates are stored in a consistent format.


---

Original Source: https://www.mindstick.com/forum/159140/how-to-convert-different-string-formats-into-date-in-oracle

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.