Re: Define Const for Date Format

From: AK <AK_TIREDOFSPAM_at_hotmail.COM>
Date: 13 Jul 2005 07:55:03 -0700
Message-ID: <1121266503.717297.219170@z14g2000cwz.googlegroups.com>

create or replace package formats
as
 function date_format return varchar2;
end formats;
Package created

create or replace package body formats
as

function date_format
return varchar2
is
begin
return 'YYYY-MM-DD HH24:MI:SS';
end date_format;
end formats;
Package body created

select formats.date_format() from dual
FORMATS.DATE_FORMAT()

---

YYYY-MM-DD HH24:MI:SS 1 row selected

select to_char(sysdate, formats.date_format()) from dual TO_CHAR(SYSDATE,FORMATS.DATE_F

---

2005-07-13 07:56:13    

1 row selected    

/
drop package formats
Package dropped Received on Wed Jul 13 2005 - 09:55:03 CDT