You gotta' love to hate them. Here's a link that shows you how to format a date in different ways on insert and select.
Also, I can never remember the default Oracle date format. It's DD-MONTH-YY, where MONTH is the month short name.
© Copyright 2004 Tom Pierce.
