Re: date functions

> how can i select sections, like the month, day, or year from a date?
> if i do a "select sysdate from dual" then i get the complete date. now i want
> only the month or day? of course, how can i select only a portion of a date
> that is stored in a data column?

Reading documentation isn't a bad thing :-)))))

                    select TO_CHAR(date,'HHMI') from table

this will return the timestamp of the date.

There are much others mask, like DD, MM,YYYY or C (century),...

Received on Tue Jan 04 2000 - 03:29:42 CST