Re: Format Date in database

I think mention of the to_char function which can be used to format the date value into almost any desired output format is also in order

to_char(date_value.'format string')

and for input to the database see to_date(:variable,'format')

See the SQL manual for all the possible format options HTH -- Mark D Powell -- Received on Sun Jan 02 2005 - 15:46:03 CST