On Friday 31 October 2008 07:09:28 am Hualan Rui wrote: > to_date Could it be that starttime is not 'text' data type? -- John Fabiani