I get the ...Element Time_Add .... cannot be converted to the currently installed version of SQL. I have a few questions:
1. Is there a list of functions that do not work with MySQL so I can avoid them?
2. What are my options for manipulating timestamps with MySQL? Do I need to upgrade? Are there other forms I can use?
cheers,
ski
Time_Add doesn't work with mysql 5.0.18
-
- Posts: 58
- Joined: Mon Nov 13, 2006 9:15 pm
- Location: Bothell, USA
-
- Posts: 58
- Joined: Mon Nov 13, 2006 9:15 pm
- Location: Bothell, USA
-
- Posts: 58
- Joined: Mon Nov 13, 2006 9:15 pm
- Location: Bothell, USA
Why doesn't this work
if Staff.LastModified > (Current-TimeStamp - 24) then
do something.
The minute I try any type of calculation in the query, the query becomes true and grabs all records. But I can create a separate object and do this:
SystemSettings.LastUpdated = Current_TimeStamp - 24
if Staff.LastModified > SystemSettings.LastUpdated then
do something
ski
if Staff.LastModified > (Current-TimeStamp - 24) then
do something.
The minute I try any type of calculation in the query, the query becomes true and grabs all records. But I can create a separate object and do this:
SystemSettings.LastUpdated = Current_TimeStamp - 24
if Staff.LastModified > SystemSettings.LastUpdated then
do something
ski
-
- Posts: 58
- Joined: Mon Nov 13, 2006 9:15 pm
- Location: Bothell, USA