Re: DATEWIDTH in Personal Oracle 7.3

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 24 Aug 1998 03:38:38 GMT
Message-ID: <35eeddfc.25572636@netnews.worldnet.att.net>

On Sun, 23 Aug 1998 19:43:54 +0100, GP
<g.pendleton_at_virgin.net> wrote:

>I wish to extend datewidth in Personal Oracle from default of 9. It
>seems I need an argument to make it stick. What do I do?

I'm not sure I understand the issue here. Are you referring to the physical width of the date field in the database filess? You can't control that. Do you just want to see a four digit year when you select a date? That's a bit easier. One way is to use TO_CHAR:

select to_char(date_field,'mm/dd/yyyy') from your_table;

Did I understand your question correctly?

Jonathan Gennick Received on Sun Aug 23 1998 - 22:38:38 CDT