Tag Info

Hot answers tagged

1

The formats accepted by to_char(timestamp, text) include localized patterns that make it not immutable. Example of different results with the same input: test=> BEGIN; test=> set lc_time='en_US.utf8'; test=> select to_char(now()::timestamp, 'TMDay'); to_char --------- Monday test=> set lc_time TO 'fr_FR.utf8'; test=> select to_char(now()::timestamp, ...



Only top voted, non community-wiki answers of a minimum length are eligible