Pular para conteúdo

Home

  • 1 min de leitura

Primeiro e último dia do ano

Primeiro e último dia do ano
1
2
3
4
select
    date('0001-01-01') + year(current date) years - 1 year first_day_of_the_year,
    date('0001-01-01') + year(current date) years - 1 day  last_day_of_the_year
from sysibm.sysdummy1;
  • 1 min de leitura

Consulta de Passagem - SQL Pass-trough

Consulta de passagem com AUTHDOMAIN
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
proc sql;
    connect to db2 (DATABASE=DB01 AUTHDOMAIN=USUARIO);
    create table dados as 
    select * from connection to db2 (
        SELECT 
        *
        FROM schema.tabela 
        WHERE data_ref = current_date;
    ) a;
    disconnect from db2;
quit;

``` SAS title="Consulta de passagem sem AUTHDOMAIN" linenums="1" proc sql; connect to postgres (server='192.168.0.1' port=5432 user=usuario password=senha db=banco); create table dados as select * from connection to postgres ( select * from schema.tabela; ) a; disconnect from postgres; quit;