|
|
Welcome to the Computer Webmaster Gaming Console Graphics Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
| |||||||
| Database Database problems or need to ask a question? maybe something to do with sql injections or a database software question. Database topics cover MySQL, PostgreSQL, Oracle, SQL Server or anything else related to databases. |
 |
| | LinkBack | Thread Tools | Display Modes |
05-31-2007, 7:37 PM
| #1 | ||
 |
Can someone help me with this. This function was working but the db was moved to a different server with a different version of sql and now the function will not work anymore. See below and see what could be wrong, any help or re-written code would be appreciated. DateTime : YYYY-mm-dd HH:MM  SServer DateTime is : 2005-01-15 08:28:12 Database DateTime is : 2005-01-15 08:28:12You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(Date_Format(datetime_stamp,'%Y-%m-%d'),DATE_FORMAT(now(),'%Y-% Mysql Client API version 4.0.14 -- Scott skr1224@comcast.net | ||
      |
| Featured Websites | ||||
|
|
| Tags: date, error, time, version |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| MDB2 - how to catch "MDB2 Error: constraint violation" error? | l Burnerheimerton | Pear | 2 | 10-04-2008 7:03 PM |
| Anyone know the release date yet? | MarchGDB | Computer Consoles | 1 | 05-30-2007 11:25 AM |
| AVG out of date?? | Kadaitcha Man | Windows | 2 | 05-28-2007 9:07 PM |
| PEAR DB ERROR: db_error: message="DB Error: insufficient data supplied" code=-20 | Kevin McCarthy | Pear | 0 | 05-20-2007 5:34 PM |
| PS3 release date? | MadKad | Computer Consoles | 2 | 10-30-2006 8:46 AM |
| Featured Websites | ||||
|
version error for time date 
PacMan
Linear Mode
