File contains date values as ‘2022-02-18 09:15:00+05:30’. But after importing to oracle table its showing all date values as ‘0014-01-20 15:11:05.000’
I have a csv file containing dates from 2015-2022 and time in 5 minutes interval date format as 2022-02-18 09:15:00+05:30. I need to change date format 2022-02-18 09:15:00+05:30 to 2022-02-18 09:15:00 So I copied and pasted the data in notepad++ and removed all +05:30 from all rows and replaced in the csv file. Format became […]
File contains date values as ‘2022-02-18 09:15:00+05:30’. But after insertion in oracle table its showing all date values as ‘0014-01-20 15:11:05.000’
I have a csv file containing dates from 2015-2022 and time in 5 minutes interval date format as 2022-02-18 09:15:00+05:30. I need to change date format 2022-02-18 09:15:00+05:30 to 2022-02-18 09:15:00 So I copied and pasted the data in notepad++ and removed all +05:30 from all rows and replaced in the csv file. Format became […]