Skip to main content
Question

Time is truncated in the timestamp column

  • Jun 20, 2023 5:23 AM UTC
  • 3 replies
  • 24 views

hoon

hello everyone

I have set the logtable to vertica in Pentaho.
I set the logdate column to timestamp type, but in the log it is 2023-06-19 00:00:00.000 and so on.
How can I get the time to be output?

3 replies

tpise
  • Participating Frequently
  • Jun 20, 2023 1:05 PM UTC

Which Pentaho product are you using?


hoon
  • Author
  • New Participant
  • Jun 20, 2023 1:19 PM UTC

This is Pentaho_CE_9.1 version


tpise
  • Participating Frequently
  • Jun 20, 2023 2:39 PM UTC

Thanks, I will check it and let you know.