Обсуждение: RES: RES: HAPPY HOUR
That is what I´ve looked for so far.
See tha way to set datestyle to brazilian style by define ISO and EUROPEAN
In addition to these general formats, PostgreSQL's date output format has two other variants which further describe how to display the date, shown in Table 3-19: European and non-European (U.S.). These determine whether the format is day followed by month, or vice versa. This variation can be applied on top of the previous four general formats with the same syntax to SET DATESTYLE and will not modify your chosen format except for the arrangement of the month and day.
Table 3-19. Extended date output formats
Month/day format | Description | Example |
---|---|---|
European | day/month/year | 12/07/2001 17:34:50.00 MET |
U.S., or Non-European | month/day/year | 07/12/2001 17:34:50.0 PST |
Furthermore, you may set both the general format and day/month convention by supplying both variables to the SET command, comma delimited. The order of these variables is not important to the SET command as long as the variables are not mutually exclusive (e.g., SQL and ISO), as shown in Example 3-26.
Example 3-26. Setting date formats
booktown=# SET DATESTYLE TO ISO,US; SET VARIABLE booktown=# SHOW DATESTYLE; NOTICE: DateStyle is ISO with US (NonEuropean) conventions SHOW VARIABLE booktown=# SET DATESTYLE TO NONEUROPEAN, GERMAN; SET VARIABLE booktown=# SHOW DATESTYLE; NOTICE: DateStyle is German with European conventions SHOW VARIABLE