How to convert string year-month into complete date in format 2018-12-01 in Pentaho Data Integrity CE
I am getting month and year in string format (2018-December) in excel file and I want to convert it into date format 2018-12-01 (day can be always 01) and write all data in PostgreSQL Database with Pentaho Data Integrations CE.
I tried to do it with select values, tab "Meta-data", Format -> yyyy-MMMM, but I got an error "couldn't convert string [2018-July] to a date using format [yyyy-MMMM]". pentaho transformation image
Can someone help me? Thank you in advance!
You're trying to convert Text data (name of the month) to Date, that won't work, you'll have to treat this data first before converting to Date type.
Since your data is coming with a separator, you can treat the second part with Value Mapper, or a Replace in string step.
After that you can concatenete the string back with a separator and then use the Select Values.
- `uuuu` versus `yyyy` in `DateTimeFormatter` formatting pattern codes?
- Failed implementation of nested ternary expressions to add ordinal suffix to day in formatted date
- Intl.DateTimeFormat options hash: Getting leading zeros with '2-digit'
- Formatting date inside bash awk command
- How to change date format and add a day to the date
- How to format a duration in java? (e.g format H:MM:SS)
- Update throwing warning instead of error and continues to run
- Month abbreviations show 4 characters instead of 3
- Android date format using SimpleDate
- Duckdb : Date values are read as numbers while reading from excel file. How to read them as dates?
- Formatting of timestamp
- How to convert date in to yyyy-MM-dd Format?
- How do I get the current date in JavaScript?
- In the Django admin site, how do I change the display format of time fields?
- Returned date of paypal payment agreement
- YYYY-MM-DD format date in shell script
- Instancio - Generate past date as string format YYYYMMDD
- How to ISO 8601 format a Date with Timezone Offset in JavaScript?
- Reformat date from Ymd to d-m-Y
- Cannot extract month name, in specified language, from date
- Format date from YYYYMMDD to YYMMDD in Javascript
- Is there a date format to display the day of the week in java?
- File contains date values as '09-01-2015 14:30:00'. But after importing to oracle table its showing all date values as '20-01-19 3:12:15.00000 PM'
- datetime to string with time zone
- Spring getting validation error with pattern dd-MM-yyyy
- Yellowbrick DB DateTime to Date type-casting not showing only date format (YYYY-MM-DD)
- PHPExcel date required dd/MM/yy
- Plotting historical periods in a timeline using R and vistime-package, BC not possible
- UTC time stamp in long form (YYYYMMDDhhmmss.mmmuuun) formatting
- how to convert LocalDate to a specific date time format