Segunda-feira, 21 de maio de 2012
Seu IP de acesso: 38.107.179.231

PUBLICAÇÕES

Banco de dados / ORACLE - Trabalhando com datas
SELECT SYSDATE data_atual, ADD_MONTHS (SYSDATE, -1) menos_um_mes, ADD_MONTHS (SYSDATE, 1) mais_um_mes, LAST_DAY (SYSDATE) ultimo_dia_mes, TRUNC (SYSDATE, 'MONTH') primeiro_dia_mes, MONTHS_BETWEEN (SYSDATE, '01-JAN-2001') qtd_mes, FLOOR (MONTHS_BETWEEN (SYSDATE, '01-JAN-2001')) arredonda_abaixo, CEIL (MONTHS_BETWEEN (SYSDATE, '01-JAN-2001')) arredonda_acima, ABS (MONTHS_BETWEEN (SYSDATE, '01-JAN-2001')) valor_absoluto, ROUND ((MONTHS_BETWEEN (SYSDATE, '01-JAN-2001')), 2) arredonda, TRUNC (SYSDATE, 'year') primeiro_dia_ano, TO_CHAR (SYSDATE, 'dd " DE " FMMONTH " DE " YYYY', 'nls_date_language=portuguese' ) diames_extenso, TO_CHAR (SYSDATE, 'FMMONTH " DE " YYYY', 'nls_date_language=portuguese' ) mes_extenso, TO_CHAR (SYSDATE, 'HH24:MI') hora_minuto, TO_CHAR (SYSDATE, 'FMMonth', 'nls_date_language=portuguese' ) mes_corrente, TO_DATE (LPAD (TO_CHAR (1234), 4, '0'), 'hh24mi') dias_data, FLOOR (FLOOR (MONTHS_BETWEEN (SYSDATE, SYSDATE)) / 12) idade, DECODE (TO_NUMBER (TO_CHAR (SYSDATE, 'D')), 2, 'segunda-feira', 3, 'terça-feira', 4, 'quarta-feira', 5, 'quinta-feira', 6, 'sexta-feira', 7, 'sabado', 1, 'domingo' ) dia_da_semana FROM DUAL

Publicado em: 12/08/08 15:44 