hello experts

please have a look of that:

select msg_datebegin from msg where msg_datebegin between
'06/02/2010 06:00:00' and '24/11/2006 06:00:00';
ORA-01830: date format picture ends before converting entire input string

the msg_datebegin column is under format '06/02/2010 06:00:00'
the error message is like the first part of the format was converted into
a valid date but not the second part.
anyone has a idea to correct this issue..?

thanks in advance
david..




(See attached file: C.htm)

Oracle LazyDBA home page