Lá vai
SELECT to_char(((date_trunc('week',current_date)::date) + (i+6)), 'DAY')
AS "DATA",
CASE
to_char(((date_trunc('week',current_date)::date) + (i+6)), 'DAY') WHEN '*
SUNDAY*' THEN '*FIM DE SEMANA*' WHEN '*SATURDAY*' THEN '*FIM DE SEMANA
*' ELSE '*DIA UTIL*' END AS "TENTATIVA"
--! *Dilson Tomé Rainov*
*Skype: dilsontome*
*MSN: [email protected]*
*(11) 8013-7803*
On Thu, Jul 26, 2012 at 2:14 PM, Dilson Tomé <[email protected]> wrote:
> Como?
> rs
>
>
>
> --! *Dilson*
>
>
>
>
> On Thu, Jul 26, 2012 at 2:11 PM, Guimarães Faria Corcete DUTRA, Leandro <
> [email protected]> wrote:
>
>> 2012/7/26 Dilson Tomé <[email protected]>:
>> >
>> > postgres=# SELECT to_char(((date_trunc('week',current_date)::date) +
>> (i+6)),
>> > 'DAY') AS "DATA",CASE to_char(((date_trunc('week',current_date)::date) +
>> > (i+6)), 'DAY') WHEN 'SUNDAY' THEN 'FIM DE SEMANA' WHEN 'SATURDAY' THEN
>> 'FIM
>> > DE SEMANA' ELSE 'DIA UTIL' END AS "TENTATIVA"
>> > FROM generate_Series(0,6) i;
>>
>> Identa…
>> _______________________________________________
>> pgbr-geral mailing list
>> [email protected]
>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
>>
>
>
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
