nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

DB Date Insert Issue

enthusiast

I am having a weird issue while inserting date field from IW to Oracle DB table. The format of the field is '02-31-2090' while the resultant field in the db end up as '1-31-2099' meaning it adds a '1' as the month part while updates day and year. Following is the DB config string that I am using:

<column name="ONLINE_SERV_EXPIRATION" data-type="DATE" data-format="mm-dd-yyyy" value-from-field="expiration_date" allows-null="no" is-url="no"/>

The table definition for the same field is:

ONLINE_SERV_EXPIRATION NOT NULL DATE
The default value of this field is '01-DEC-99'.

The log suggest that it converts the said field to TimeStamp without any error:

DBD: Column: ONLINE_SERV_EXPIRATION, field: expiration_date, Index: 12,Converting '02-31-2090' to TIMESTAMP

I just tried deploying it using "MM-dd-yyyy" but it failed again with the following error:
DBD: ERROR Smiley Frustrated

impleDateFormat.parse() could not parse the string '11-31-2099' with format: MM-dd-yyyy
DBD: ERROR:data-format attribute for the column must conform to the format documented in SimpleDateFormat class

Find more posts tagged with

Comments

Phanie

I am having a weird issue while inserting date field from IW to Oracle DB table. The format of the field is '02-31-2090' while the resultant field in the db end up as '1-31-2099' meaning it adds a '1' as the month part while updates day and year. Following is the DB config string that I am using:

The table definition for the same field is:

ONLINE_SERV_EXPIRATION NOT NULL DATE
The default value of this field is '01-DEC-99'.

The log suggest that it converts the said field to TimeStamp without any error:

DBD: Column: ONLINE_SERV_EXPIRATION, field: expiration_date, Index: 12,Converting '02-31-2090' to TIMESTAMP

In data-format when data-type is "date" or "datetime"
'M' - stands for month in year
'm' - stands for minutes

so the data-format in this case should be - 'MM-dd-yyyy'

--
Phanie

enthusiast

I tried MM-dd-yyyy but it keeps on failing.

pammi

I used like this :

it worked for me.

Thanks

Phanie

I used like this :

it worked for me.

Thanks

Fixing post ...

I used like this
[html]

[/html]
it worked for me.

BlueWhale

Hello enthusiast,

You're saying that

ONLINE_SERV_EXPIRATION NOT NULL DATE
The default value of this field is '01-DEC-99'.

So, the timestamp should be in dd-MMM-yy format. But, in your deployment config. you're using:
[html]

[/html]

which contradicts it. Please follow the same format in your DCR, deployment config file that you see in DB.

enthusiast

Tried all option but nothing's working.

NestedSDS.zip

Migrateduser

I just tried deploying it using "MM-dd-yyyy" but it failed again with the following error:
DBD: ERRORimpleDateFormat.parse() could not parse the string '11-31-2099' with format: MM-dd-yyyy
DBD: ERROR:data-format attribute for the column must conform to the format documented in SimpleDateFormat class

can you try that format again with a valid date, like 11-30-2099 and then post the log errors

merry

Hi enthusiast,

I have faced similar issue in past, though date format was different for me. Following is the code that worked for me. Hope this helps you as well.

[html]

[/html]