Date type field in database

bhavya123

I have a scenario that I am not able to update the date type of feilds in database through Data Deploy 6.2. It seems that it is the caching issue of the interwoven temp tables in database. In a local database I drop the these temp tables like: IWTempAD60C4, then it works.

My query is that can it be the only issue, and what other alternative approach can be there for it, so I think deleting temp tables in production environment s not the right approach.

Adam Stoller

I have a scenario that I am not able to update the date type of feilds in database through Data Deploy 6.2. It seems that it is the caching issue of the interwoven temp tables in database. In a local database I drop the these temp tables like: IWTempAD60C4, then it works. My query is that can it be the only issue, and what other alternative approach can be there for it, so I think deleting temp tables in production environment s not the right approach.

Did you remember to set the

db-datetime-format

attribute for that column / field in your DD config file? And did you make sure you did it correctly?
We had a similar issue recently and it was because we used "mm" instead of "MM" for the format - the former is for minutes, the latter is for months.