Yes, but is not about timezone dependency, it is about the other dependencies listed in the second and third points. Namely the datestyle setting and magic strings e.g. 'now'
I am sorry, I still don't understand. to_date and to_timestamp require datestyle settings per se and magic strings don't work.
=# -- required datestyle =# select to_date('2000-01-01'); ERROR: function to_date(unknown) does not exist LINE 1: select to_date('2000-01-01'); ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
=# -- magic strings don't work =# select to_date(''); ERROR: invalid value "epoc" for "YYYY" DETAIL: Value must be an integer. =# select to_date('epoch', 'YYYY-MM-DD'); ERROR: invalid value "epoc" for "YYYY" DETAIL: Value must be an integer. =# select to_date('infinity', 'YYYY-MM-DD'); ERROR: invalid value "infi" for "YYYY" DETAIL: Value must be an integer. =# select to_date('-infinity', 'YYYY-MM-DD'); ERROR: invalid value "-inf" for "YYYY" DETAIL: Value must be an integer. =# select to_date('now', 'YYYY-MM-DD'); ERROR: invalid value "now" for "YYYY" DETAIL: Value must be an integer. =# select to_date('today', 'YYYY-MM-DD'); ERROR: invalid value "toda" for "YYYY" DETAIL: Value must be an integer. =# select to_date('tomorrow', 'YYYY-MM-DD'); ERROR: invalid value "tomo" for "YYYY" DETAIL: Value must be an integer. =# select to_date('yesterday', 'YYYY-MM-DD'); ERROR: invalid value "yest" for "YYYY" DETAIL: Value must be an integer. =# select to_date('allballs', 'YYYY-MM-DD'); ERROR: invalid value "allb" for "YYYY" DETAIL: Value must be an integer. Regards, Sven
