Jump to content

Does mysql 4.0.15 support date()?


ngubie

Recommended Posts

Hi guys,

I got mysql 4.0.15 running on my computer, but 4.1.16 running on the network in the office. I used to design the site on my computer, then transfer it over to the office server, and everything was working fine.

Then my personal comp got wiped, I reinstalled the local server, and now the mysql queries arent working anymore.

I've narrowed the problem down to the date() function. if I do
[i]date(modtime)[/i]
I get a query syntax error. but if I just do
[i]modtime[/i]
everything works, but I get the whole timestamp instead of just the date.

Everything on the office server still works just as it should, but I would really like to get it up and running properly on my personal comp too, so...

Does mysql 4.0.15 support the date() function?
Why did it work before the wipe, but not after, even though everything should be the same still?
Is there anything I can do to get it running on the personal comp? I really don't want to change the coding if it should be working properly but isnt due to a server problem.

Thanks
Link to comment
Share on other sites

[quote=MySql manual]
DATE(expr)
Extracts the date part of the date or datetime expression expr.
mysql> SELECT DATE('2003-12-31 01:02:03');
        -> '2003-12-31'

DATE() is available as of MySQL 4.1.1.
[/quote]

So if I can find it in the manual, why can't you?

http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.