On 9 May, 14:35, Captain Paralytic <paul_laut...@yahoo.com> wrote:
> The following from the manual works fine:
> SELECT MAKEDATE(2001,365), MAKEDATE(2004,365);
>
> However:
> SELECT MAKEDATE(2001,365), MAKEDATE(2004,365) FROM A;
>
> Gives the error:
> #1064 - You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near '( 2001 , 365 ) , MAKEDATE ( 2004 , 365 ) FROM A LIMIT 0, 30'
> at line 1
>
> This is on 4.1.22
>
> What am I doing wrong?

Must be a version bug, works fine in v5