Re: [REPOST] The "TO_DATE" Function Question

aleatory_at_hotmail.com (aleatory) writes:

> [...]
> | SQL> SELECT last_name, registration_date,
> | 2 TO_CHAR ( registration_date, 'MM/DD/YYYY' )
> | 3 FROM student
> | 4 WHERE registration_date = '22-JAN-99'
> | 5 /
>
> After executing this, the program displays:
>
> | no rows selected

The DATE datatype is able to store date and time with a resolution of seconds. So maybe you have to strip off the time part of registration_date with the trunc(date function) to get the result.

-- 
Franz Zahaurek                          fzk_at_gams.at
Vienna, Austria, Europe                 http://www.fzk.at