Re: DATEWIDTH in Personal Oracle 7.3

Jonathan Gennick wrote:
>
> 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

Thanks for your help but maybe I'm going about this the wrong way. I want to insert/query full date and time into a date field but I only have room for 9 characters. I cannot seem to change this. Is the above reply still applicable?

Thanks George Received on Wed Aug 26 1998 - 04:21:01 CDT