PDA

View Full Version : treat dates with Pentaho metadata ?



jonathansauret
10-13-2008, 05:47 AM
Hello every body!

I would like to know if it's possible to make treatment on dates with Pentaho Metadata editor.

To be clear, I have a date at the format "20.02.2008, 17:15:58.574". From this date, I would like to create 3 news physical columns, one for the year, one for the month and one for the day.

Is it possible. And how?

Thank you for you answers

Jonathan

davidl
10-13-2008, 09:41 AM
What database are you using as the backend?

jonathansauret
10-13-2008, 03:06 PM
i'm using a firebird database!

But i found answers with the help of this forum :
http://forums.pentaho.org/showthread.php?t=62343

Thanks David for your interest!