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
<http://www.commandprompt.com/ppbook/index.lxp?lxpwrap=x2632%2ehtm#EXTENDEDD
ATEOUTPUTFORMATS> 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
<http://www.commandprompt.com/ppbook/index.lxp?lxpwrap=x2632%2ehtm#SETTINGDA
TEFORMATS> 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