martedì 30 giugno 2009

How to retrieve the first day of the month

Since there isn't a "first_day" function, we can use the trunc function:

trunc(to_date('22-AUG-03'), 'MONTH') would return '01-AUG-03'

Nessun commento:

Posta un commento