Hi. My view has a field with timestamp. Although, the field type is "text". I really only want to get a date from the field, but I don't know how.
Here is an example of the text field:
2019-12-21T13:15:49.000-0600
2019-10-02T15:01:43.000-0500
I need to be able to join this to another view on date. The other view has a date in the following format: 2020-05-05 (returned using to_localdate on a timestamp field). Ideally, I'd like to be able to get the text field above to return a date in similar format: 2019-12-21, 2019-10-02.
I thought I would try to_localdate or to_timestamp. But, I think I'm getting the expression wrong due to the way the text is formatted (things I tried):
to_timestamp('yyyy-MM-dd''T''HH.mm.ss.SSS', end_timestamp)
to_timestamp('yyyy-MM-dd''T''HH.mm.ss.SSS''Z', end_timestamp)
to_localdate('yyyy-MM-dd''T''HH.mm.ss.SSS', end_timestamp)
to_localdate('yyyy-MM-dd''T''HH.mm.ss.SSS''Z', end_timestamp)
I'd appreciate any suggestions.