On 27 February 2017 at 10:52, Sven R. Kunze <srkunze@xxxxxxx> wrote:
So, what can I do to parse texts to date(times) in a safe manner?
You know best the format of your data; if you know that your date field is always in a particular style and timezone, you can write a function that can be considered safe to set IMMUTABLE, where a more generic system todate function cannot.
It might be sensible to call the function something that describes it exactly, rather than my_to_date you could call it utc_yyyymmdd_todate or something, just in case someone comes along later and sees an immutable todate function and thinks they can use it for something else.
Geoff
