Home > database >  SQLLDR import time format
SQLLDR import time format

Time:10-01

Everyone a great god, and a more strange problems,
When we SQLLDR storage time format is so defined

After the results into a repository, they became so, table fields is indeed a date type, was the first time see this time format,

This is a question of database environment?
Is the operating system is 11.2.0.1.0 redhat6.5 database

CodePudding user response:

Timestamp and date types are still a little difference

CodePudding user response:

reference 1st floor sxq129601 response:
timestamp and date type or a little difference between

Hello, is that we have two projects, all use the same script, table structure are all the same, but one of the data is 2017/1/16 20:45:00 form, and another is 2017/1/16 2024:45:00 form, so I just want to, will be on both sides of the environment caused by inconsistent,
  • Related