MAKEDATE error???
This is a discussion on MAKEDATE error??? within the MySQL Database forums, part of the Database Forums category; The following from the manual works fine: SELECT MAKEDATE(2001,365), MAKEDATE(2004,365); However: SELECT MAKEDATE(2001,365), MAKEDATE(...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
05-09-2008
|
|||
|
|||
MAKEDATE error???
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? 
|
|
05-09-2008
|
|||
|
|||
|
Re: MAKEDATE error???
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
|
|
05-13-2008
|
|||
|
|||
|
Re: MAKEDATE error???
Captain Paralytic wrote:
> 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 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/
|
|
05-13-2008
|
|||
|
|||
|
Re: MAKEDATE error???
On 13 May, 08:23, Willem Bogaerts <w.bogae...@kratz.nl> wrote:
> Captain Paralytic wrote: > > 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 > > 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.
|
Linear Mode
