Re: SPL DATETIME bug ????
Paul Watson wrote:
> This is all in SPL, Solaris 8, 9.40UC3
>
> select count(*)
> from table1, table2
> where join
> and datetime between "2004-09-29 09:57:58.00"
> AND "2004-12-29 09:57:58.00">
> returns 0.3 seconds
>
> but
>
> let l_dte1 = "2004-09-29 09:57:58.00"
> let l_dte2 = "2004-12-29 09:57:58.00"
>
> select count(*)
> from table1, table2
> where join
> and datetime between l_dte1 and l_dte2>
> returns 6.5 seconds
>
> The query plan is identical in both, all datetimes are y-f2
>
> Any straws gratefully grasped
>
>
>
What is the datatype of l_dte1 and l_dte2?