Hey guys,
I've got a problem withe the WHERE clausule of my query.
In my database records are stored and all have a field Start_Timestamp and Stop_Timestamp (both Date/Time format)
When I execute a query like :
I get an error saying the data types aren't correct.
Is there a way to convert '1-3-2005 14:32:17' to the right date format?
Or is there something else I'm doing wrong here?
Linux IS userfriendly.
It's only very selective about who it's friends are.
I've got a problem withe the WHERE clausule of my query.
In my database records are stored and all have a field Start_Timestamp and Stop_Timestamp (both Date/Time format)
When I execute a query like :
Code:
SELECT * FROM table WHERE number = 1000
AND Start_Timestamp > '1-3-2005 14:32:17'
ORDER BY number
I get an error saying the data types aren't correct.
Is there a way to convert '1-3-2005 14:32:17' to the right date format?
Or is there something else I'm doing wrong here?
Linux IS userfriendly.
It's only very selective about who it's friends are.