Re: ProC Date

A copy of this was sent to NeedaHoliday
(if that email address didn't require changing) On Tue, 22 Dec 1998 16:41:30 GMT, you wrote:

>Could someone please help. I know this is simple but for a non C
>programmer, how do I code the ProC to display a date. i.e 31/12/98.
>
>Thanks in advance

simply select to_char( your_date_field, 'dd/mm/yy' ) from your_table.....  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/    -- downloadable utilities
 
----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation
 
Anti-Anti Spam Msg: if you want an answer emailed to you, 
you have to make it easy to get email to you.  Any bounced
email will be treated the same way i treat SPAM-- I delete it.