Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Web CMS (TeamSite)
The data-type="DATE" occur wrong day
System
Hi all,
To ask for advice,the data-type="DATE" occur wrong day.
dadacapture.cfg
====================================================================================
<database deploy-column="t" searchable="f" data-type="DATE" data-format="yyyy-mm-dd" />
====================================================================================
log
====================================================================================
Parameter Index: 5, Value: 2003-05-14, Converting '2003-05-14' to DATE
Column: SDATE, field: SDATE, Index: 5,Converting '2003-05-14' to DATE
====================================================================================
Value is "2003-05-14"¡Abut deploy to db2 Value become "2003-01-14"
Month become "01".
no matter month is "01","02","03",...,"11","12", always become "01"
Why? What's happen?
Sincerely,
Joe.
Find more posts tagged with
Comments
Adam Stoller
Try using MM instead of mm. The former is for month, the latter is for minutes. This is documented in the DataDeploy Administration Guide.
--fish
(Interwoven Senior Technical Consultant)
Migrateduser
yes!
I use data-format="yyyy-MM-dd".
every thing is fine.
THX for ghoti.
