# Date conversion- String to Datetime

**URL:** <https://forum.inductiveautomation.com/t/date-conversion-string-to-datetime/71698>\
**Category:** Ignition\
**Tags:** vision, ignition81, scripting, database\
**Created:** [March 28, 2023, 11:11am UTC](https://forum.inductiveautomation.com/t/date-conversion-string-to-datetime/71698 "2023-03-28T11:11:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Priyanka.Khandge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/priyanka.khandge/32/35989_2.png) [@Priyanka.Khandge](https://forum.inductiveautomation.com/u/Priyanka.Khandge)\
**Post date:** [March 28, 2023, 11:11am UTC](https://forum.inductiveautomation.com/t/date-conversion-string-to-datetime/71698/1 "2023-03-28T11:11:18Z")

</div>

Hi guys,

I'm trying to convert the string date to DateTime format following the way:  
Insert date from power table to database.

```auto
Date = dsData.getValueAt(rowIndex,'Date')
date = system.date.parse(Date, "yyyy-MM-dd hh:mm:ss.SSS")

```

Got error

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/1/f1dbefbcf0dfbb00f98041e15945f9cee82bfde3.png)

Required this format (database format):  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/5/d56284b61e05ba852ba4dc3c1b08880c477aaf3b.png)

Ignition - 8.1.17  
SQL Server 16

Any suggestion?

Thanks,  
Priyanka

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [March 28, 2023, 11:57am UTC](https://forum.inductiveautomation.com/t/date-conversion-string-to-datetime/71698/2 "2023-03-28T11:57:22Z")

</div>

the format string in [system.date.parse()](https://docs.inductiveautomation.com/display/DOC81/system.date.parse) requies it to match the format of the string coming in.

```python
date = system.date.parse(Date, 'dd.MM.yyyy')

```

---

<div class="post-metadata">

**Author:** ![Priyanka.Khandge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/priyanka.khandge/32/35989_2.png) [@Priyanka.Khandge](https://forum.inductiveautomation.com/u/Priyanka.Khandge)\
**Post date:** [March 28, 2023, 11:59am UTC](https://forum.inductiveautomation.com/t/date-conversion-string-to-datetime/71698/3 "2023-03-28T11:59:38Z")

</div>

@JordanCClark Thank you so much.

Work perfectly!!