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

Responder a