Question

Timestamp Format

  • 14 September 2022
  • 2 replies
  • 271 views
L
Rank

Is it possible to load time data into a Date field?

Using a Migration Job, I’m trying to load a time value into Day Type Details (FTIME field) but can’t get the date value (06:00:00.0000000) to parse properly:

Error formatting date value 06:00:00.0000000 for FTIME

 

I’ve also tried 06:00 and set the Date Format to hh:mm without success.

2 replies

Kelum Pradeep Kumara
Rank
Userlevel 7
Badge +18

I think you have to use TRUNC function
ex: If the sysdate with time is => 9/14/2022 7:50:13 AM
Select trunc(sysdate) returns => 9/14/2022

Please try this.

-Kelum Niranjana
Jens
Rank
Userlevel 4
Badge +8

I suppose you have created 2 migration jobs in the old migration tool (FndMig):

  1. to load the raw data into an IC-table (CREATE_TABLE_FROM_FILE)
  2. to migrate the data from the IC-table into a LU

Regarding the 1st migration job I recommend to load this FTIME value into a VARCHAR2 field.

With the 2nd migration job you can convert the content of this VARCHAR2 field using ORACLE SQL functionality how you want to have it at the end.

Using the Date Format field in the File Configuration of the 1st migration job doesn’t work in your case because this Date Format only allows dates without any time stamp.

 

Reply


Terms & ConditionsCookie settings