Re: A simple "date" question

From: David Smith <skandor_at_worldnet.att.net>
Date: Wed, 5 May 1999 09:28:08 -0500
Message-ID: <7gpkf1$6nu$1@bgtnsc01.worldnet.att.net>

Forgot one thing. When retrieving it is SQL*Plus to check use select to_char('date_column','dd-mon-yyyy') date_column from table_name;

This will put your fears to rest.

b.t.w. some will tell you that 'dd-mon-rr' in a form works. It does for the most part, but if your building a new form, it's always best to use 4 digit years. My opinion.

David Smith wrote in message <7gpk9e$67k$1_at_bgtnsc01.worldnet.att.net>...
>Make the length 11 of your base table item in the form and give it the
>format mask 'DD-MON-YYYY'
>
>
>mesterlars_at_my-dejanews.com wrote in message
><7gpctu$b6d$1_at_nnrp1.dejanews.com>...
>>Hi
>>
>>I have a question for all you hardcore Oracle-programmers
>>out there. I have created a date attribute in a table.
>>How do I insert dates with 4 digits in the year. I'm using
>>Forms 4.5.
>>
>>Ex. I wan't to insert '05-apr-1999' in the table.
>>
>>Hope somebody can help
>>
>>Lars
>>
>>-----------== Posted via Deja News, The Discussion Network ==----------
>>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>
Received on Wed May 05 1999 - 09:28:08 CDT