Sample Header Ad - 728x90

How to set Postgresql database to see date as "MDY" permanently

30 votes
3 answers
74610 views
How can I set my database to see the 'date' as "MDY" without running: SET datestyle = "ISO, MDY"; every-time I'm trying to access it? I'm using Postgresql version 9.1, Ubuntu 12.04. My system locale, at the time of the database installation was set to en_CA.utf8 and I recently changed it to en_US.utf8. show lc_CTYPE returns: --> "en_CA.UTF-8" but show LC_CoLLATE returns: --> "en_CA.UTF-8"
Asked by Timka (415 rep)
Jun 21, 2012, 05:13 PM
Last activity: Oct 14, 2023, 03:51 AM