miércoles, 2 de septiembre de 2009

FUNCTION SQL Examples

FUNCION TO_CHAR

SQL> SELECT DISTINCT(TO_CHAR(HGO_FCH_REGISTRO,'YYYY')) FROM HIS_SEG_OFERTA;

(TO_CHAR(HGO_FCH_REGISTRO,'YYY
---------------------------------------------------------------------------
2009
2019
2006
2008
2007
2005
2022

SELECT * FROM HIS_SEG_OFERTA WHERE TO_CHAR(HGO_FCH_REGISTRO,'YYYY') > 2009
/