Categories
View Replies (1)

Resolved Date/Time error

  1. ibrouwer
    ibrouwer
  2. RO CSVI
  3. Saturday, 25 June 2022
  4.  Subscribe via email
I receive the following error in my log:
"Not added. Error: Incorrect datetime value: '11/06/2009 17:05:46' for column `brouwe29_joomla`.`gijsbr_content`.`created` at row 1"

How can I correct this ?
0
Responses (1)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
The database supported date format is Y-m-d H:i:s. Since your date format is d/m/Y H:i:s you see error on import. You should change 11/06/2009 17:05:46 format to 2009-06-11 17:05:46 to solve the error. There are two ways to solve this

1. If you are exporting using RO CSVI and using the export file to import then in the export template on File tab set the Date format field to Y-m-d H:i:s and run the export. See attached screenshot.
2. You can also change the date format using RO CSVI Multi replace rule and by using Custom date format operation. Apply this rule on all date fields in import template.
Attachments (1)
Screenshot 2022-06-27 at 10.06.52 AM.png Screenshot 2022-06-27 at 10.06.52 AM.png
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!