Re: Beginners Question.

From: Brian Everett <beverett_at_remove_this.usa.net>
Date: Sun, 18 Oct 1998 05:47:03 GMT
Message-ID: <3629801a.711515615@news.earthlink.net>

You could update the field with the 'to_date' function. Or just use the 'to_char' function to store the date and the 'to_date' function to evaluate it.
Your choice.

On Sat, 17 Oct 1998 22:56:20 GMT, "dpinto" <dpinto97_at_usa.net> wrote:

>I have a problem i have a table where i have a field that has a date
>but varchar2 and it looks like this 981231 actualy that is a date i
>need to update that to a date field, and at some point i need to insert
>it as a date field what should i do to accomplish that?
>
>Can anyone help me?

Good Luck! Brian_RestonVA
Oracle GEHS Received on Sun Oct 18 1998 - 00:47:03 CDT