Search results for query: *

I see where I can convert from a CHAR to a DATE and vice-versa...Is there a way to convert a DATE to an int?

I am generating a C program for specific queries and am having trouble with the DATE type. When I create a struct for a Table how do I declare this datatype? example: struct { VARCHAR staffNo[ID_LEN]; VARCHAR fName[UNAME_LEN]; VARCHAR lName[UNAME_LEN]; char sex...

Thank you, worked like a charm

I need to remove a FOREIGN KEY constraint to add new data but I can't seem to do it. I know it would be: ALTER TABLE Clients DROP CONSTRAINT constraint_name but that is if you gave the constraint a name, I created the foreign key constraint when I created the table, and did not designate a name...