Liquibase export a wrong Timestamp format
Database Subsetter and Relational Data Browser
Brought to you by:
rwisser
I found a bug in the liquibase export feature, when exporting a timestamp field, the pattern used to format is incorrect. It uses the day of year, instead of the day of month.
Fix is simple, in LiquibaseXMLTransformer
use lower 'y' and lowerd 'd' in patterns
this.datePattern = new SimpleDateFormat("yyyy-MM-dd", Locale.ENGLISH);
this.timePattern = new SimpleDateFormat("hh:mm:ss", Locale.ENGLISH);
this.timestampPattern = new SimpleDateFormat("yyyy-MM-dd'T'hh:mm:ss", Locale.ENGLISH);
Anonymous
Will create a bug for this one, and attach a patch.