Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Format datetime

  1. #1
    Join Date
    Apr 2012
    Posts
    5

    Default Format datetime

    How can I format a datetime in the CDE ?

    In mysql is the default yyyy-mm-dd hh-mm-ss, but I want to appear in my dashboard table as dd-mm-yyyy hh-mm-ss.

    I tried to use the function the Pentaho offers: FORMAT(column_name,format), but it not working.

    What can I do?

  2. #2
    Join Date
    Dec 2009
    Posts
    609

    Default

    Hi,

    usually you can specify the format-mask for a date-column in the "Attributes" section when selecting a date-field. (Pulling a column from the data-set onto your report-canvas usually creates such date-field)

    HTH,

    Tom

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.