Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Como faço para limitar load de anos , exemlo quero carregar de 2008 ate 2014.
LOAD
DATA_ENT ,
YEAR(DATA_ENT) AS [ANO],
MONTH(DATA_ENT) AS [MES],
DAY(DATA_ENT) AS [DIA],
WEEKDAY(DATA_ENT) AS [DIA DA SEMANA],
HOUR (DATA_ENT) AS [HORA EMISSAO],
MINUTE (DATA_ENT) AS [MINUTOS];
SQL SELECT DATA_ENT
FROM NOME TABELA;
Olá Marcelo, você pode fazer assim:
LOAD
DATA_ENT ,
YEAR(DATA_ENT) AS [ANO],
MONTH(DATA_ENT) AS [MES],
DAY(DATA_ENT) AS [DIA],
WEEKDAY(DATA_ENT) AS [DIA DA SEMANA],
HOUR (DATA_ENT) AS [HORA EMISSAO],
MINUTE (DATA_ENT) AS [MINUTOS]Where YEAR(DATA_ENT) >=2008;
SQL SELECT DATA_ENT
FROM NOME TABELA
Você tambem pode fazer essa limitação pelo SQL, mais a instrução Wherer pode variar conforme o banco de dados.
Abraços.
Tonial.
LOAD
DATA_ENT ,
YEAR(DATA_ENT) AS [ANO],
MONTH(DATA_ENT) AS [MES],
DAY(DATA_ENT) AS [DIA],
WEEKDAY(DATA_ENT) AS [DIA DA SEMANA],
HOUR (DATA_ENT) AS [HORA EMISSAO],
MINUTE (DATA_ENT) AS [MINUTOS];
SQL SELECT DATA_ENT
FROM NOME TABELA
Where YEAR(DATA_ENT)>=2008 and YEAR(DATA_ENT)<=2014 ;
Olá Marcelo, você pode fazer assim:
LOAD
DATA_ENT ,
YEAR(DATA_ENT) AS [ANO],
MONTH(DATA_ENT) AS [MES],
DAY(DATA_ENT) AS [DIA],
WEEKDAY(DATA_ENT) AS [DIA DA SEMANA],
HOUR (DATA_ENT) AS [HORA EMISSAO],
MINUTE (DATA_ENT) AS [MINUTOS]Where YEAR(DATA_ENT) >=2008;
SQL SELECT DATA_ENT
FROM NOME TABELA
Você tambem pode fazer essa limitação pelo SQL, mais a instrução Wherer pode variar conforme o banco de dados.
Abraços.
Tonial.
Alessandro
Aresento erro :
ErrorSource: OraOLEDB, ErrorMsg: ORA-00904: "YEAR": identificador inválido
SQL SELECT DATA_ENT
FROM ADMWPD.FAPACCAD
Where YEAR(DATA_ENT)>=2008 and YEAR(DATA_ENT)<=2014
missing comma after ...
LOAD
DATA_ENT,
so it takes Year as a field ...
Just add ,
Tonia
Obrigao mais uma vez pela ajuda!!!!!!!!
... Only I don't understand why my answer is wrong for you but ...
Alessandro
Meu banco de dados é o oracle , tb nao entendi poque nao aceita sua expressao
Marcelo, talvez assim funcione em seu SQL.
LOAD
DATA_ENT ,
YEAR(DATA_ENT) AS [ANO],
MONTH(DATA_ENT) AS [MES],
DAY(DATA_ENT) AS [DIA],
WEEKDAY(DATA_ENT) AS [DIA DA SEMANA],
HOUR (DATA_ENT) AS [HORA EMISSAO],
MINUTE (DATA_ENT) AS [MINUTOS] ;
SQL SELECT DISTINCT DATA_ENT
FROM NOME TABELA
WHERE EXTRACT(YEAR FROM DATE DATA_ENT) >= 2008;