To_timestamp

1

Hi.
My problem is below.

select to_timestamp(‘20180417T051318400’, ‘yyyymmdd hh24missms’) from a_table;

I expect…
2018-04-17 05:13:18.4+09

but metabase’answer is
Thursday, April 17, 2018 5:13 AM

How to fix this problem?

2

Related feature request you can :+1: vote on:

I don’t know if there are any workarounds to maybe manually format it as a text field and under admin force Metabase to format it as something that is not a date time type.

I’m sure one of the SQL gurus will be around shortly to chime in on that :smiley:

3

All the views I use have extra columns formatting the dates to the more sensible options , typically dd-mm-yyyy (sorry left-pondians), hh:nn, dd-MMM etc. You can sort by the ‘real date’, but display the properly formatted version.
It’s not ideal, but is hopefully temporary.

1 Like