Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: student needs help with SQL
TO_DATE('1998','YYYY')
Prescott Pym wrote in message <6hk785$he9$1_at_m2.c3.telstra-mm.net.au>...
>Can anyone help me out....
>
>for an assignment we have a table called film which stores info about
>films....what i can't figure out is how to use the insert command to insert
>the year made into a date object, ie
>
>insert into film(film_no, film_name, filmmaker_id, date_added, year_made)
>values('1', 'X-Files Movie', '1', '12 May 1998', TO_CHAR(1998, 'YYYY');
>
>we have to store the date as YYYY, I don't know how to do it..
>
>any help appreciated
Received on Wed Apr 22 1998 - 09:52:12 CDT