MAKEDATE error???

#1

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?

#2

On 9 May, 14:35, Captain Paralytic <paul_laut... (AT) yahoo (DOT) com> wrote:

Quote:

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

#3

Captain Paralytic wrote:

Quote:

On 9 May, 14:35, Captain Paralytic <paul_laut... (AT) yahoo (DOT) 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
No, it is a server "mode" setting. Note that there is a space character

between the function name and the opening parenthesis.

So, to the Original Poster: do not use whitespace between the function
names and their parameter list.

Best regards,
--
Willem Bogaerts

Application smith
Kratz B.V.
http://www.kratz.nl/

#4

On 13 May, 08:23, Willem Bogaerts <w.bogae... (AT) kratz (DOT) nl> wrote:

Quote:

Captain Paralytic wrote:
On 9 May, 14:35, Captain Paralytic <paul_laut... (AT) yahoo (DOT) 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

No, it is a server "mode" setting. Note that there is a space character
between the function name and the opening parenthesis.

So, to the Original Poster: do not use whitespace between the function
names and their parameter list.

Best regards,
--
Willem Bogaerts

Application smith
Kratz B.V.http://www.kratz.nl/

Note to Willem. You are wrong. The error message is displayed with a
space, but the query (as pasted at the top of the post) has NO space.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

MAKEDATE error???

comp.databases.mysql comp.databases.mysql

MAKEDATE error??? - 05-09-2008 , 09:35 AM

Re: MAKEDATE error??? - 05-09-2008 , 09:53 AM

Re: MAKEDATE error??? - 05-13-2008 , 02:23 AM

Re: MAKEDATE error??? - 05-13-2008 , 03:49 AM